Home

DAX formula to combine two criteria in one column

%3CLINGO-SUB%20id%3D%22lingo-sub-283666%22%20slang%3D%22en-US%22%3EDAX%20formula%20to%20combine%20two%20criteria%20in%20one%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-283666%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20like%20to%20incorporate%20a%20dax%20formula%20or%20other%20dynamic%20function%20into%20my%20power%20pivot%20to%20have%20an%20additional%20criteria%20added%20which%20is%20the%20sum%20of%20two%20other%20criteria.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20is%20a%20basic%20power%20pivot%20example%20of%20my%20workbook.%20I%20have%204%20categories%20and%20I%20want%20a%205th%20category%20in%20the%20pivot%20table%20which%20is%20the%20sum%20of%20Revenue%20and%20Support%20(boxed%20in%20red).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F59256i36435E69517EC659%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Excel%20Pivot%20Table%20Question.JPG%22%20title%3D%22Excel%20Pivot%20Table%20Question.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERoy%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-283666%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Roy Roongseang
New Contributor

Hello,

 

I'd like to incorporate a dax formula or other dynamic function into my power pivot to have an additional criteria added which is the sum of two other criteria. 

 

Attached is a basic power pivot example of my workbook. I have 4 categories and I want a 5th category in the pivot table which is the sum of Revenue and Support (boxed in red). 

 

Excel Pivot Table Question.JPG

 

Thank you,

 

Roy

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies