Forum Discussion
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...
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.
