Forum Discussion

Kavya123's avatar
Kavya123
Helper III
7 years ago
Solved

Group By in DAX Measure

Hi Everyone,   I need to create a measure and do group by based on the Company name. For the below expression I need to get the values based on the aggregation of Company name. Please help me on th...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Kavya123 

    If you use your formula in a measure, then you could only add "company name" and this measure in a table or matrix visual.

    Measure = CALCULATE(sum( Sheet2[answertest]) , FILTER(Sheet2, CONCATENATE(Sheet2[Answer Text], Sheet2[Answer Text])="YesYes" ))

    Or if you want to show all columns and measures together in a table visual, you could create another measure

    Measure 2 = CALCULATE([Measure],ALLEXCEPT(Sheet2,Sheet2[company name]))

     

    Best Regards

    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Kavya123 

If you use your formula in a measure, then you could only add "company name" and this measure in a table or matrix visual.

Measure = CALCULATE(sum( Sheet2[answertest]) , FILTER(Sheet2, CONCATENATE(Sheet2[Answer Text], Sheet2[Answer Text])="YesYes" ))

Or if you want to show all columns and measures together in a table visual, you could create another measure

Measure 2 = CALCULATE([Measure],ALLEXCEPT(Sheet2,Sheet2[company name]))

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.