Group By in DAX Measure

[Kavya123]

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 this.

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

[v-juanli-msft · Accepted solution]

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.

[d_gosbell]

If you drag Company Name and your measure onto a visual the Group By will happen automatically. However your measure looks overly complicated. Have you tried the following pattern?

CALCULATE(sum( PROFILERTABLENEWSUBMITTED[answertest])
    , PROFILERTABLENEWSUBMITTED[Answer Text] = "Yes"
    , PROFILERTABLENEWSUBMITTED[Answer Text])="Yes"
)

[Kavya123]

Hi,

Thanks for the reply. I have tried that but it is not working.

[d_gosbell]

We can't really help much based on "it's not working".

Can you maybe paste in 5-10 example rows of data and then show us an example of the result you would expect the calculation to produce from that sample data?