CODEWITHSUNDEEP
powerbidax
KReEd
KReEd

Reputation: 378

Group by in DAX

I am new to power bi, i have my data like -

dept. value1 value2
application & int 28 3088
Business oper. 17 2912
application & int 12 765
Business oper. 43 5449

I need to calculate group by of dept and then calculate sum of value 1 divided by sum of value 2 My output table should look like-

dept. cal_value
application & int 0.01
Business oper. 0.007

please help me to get this output

Upvotes: 0

Views: 301

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89371

Just write a measure for cal_value and the Power BI visuals will take care of the grouping. IE when you add dept and cal_value to a table, you'll get your desired result.

Upvotes: 1

Related Questions