Forum Discussion
Row wise Calculation
Hi, I fail to do the row-wise calculation in DAX measure. I attached screenshots for your reference. Company State A B C D A 1 2 5 10 B 2 3 6 20 C 3 4 7...
Hi Anonymous ,
This is what you want.
But your table columns are actually aggregated like this.
So is it a mistake in your expression?
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous , is first one a visual table and actual table. If it is a visual table, You can take the company and Sum of Sales, That should give you.
else you need to unpivot first : https://radacad.com/pivot-and-unpivot-with-power-bi
amitchandak Yes, the first table is the visual table made using Matrix visulaization.