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