Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Thanks Advaced,
My prob is have to calculate row level percentage in matrix report.
Table Explain:
Month from - Month master
Product (A,B,C) from - Product Master
Sales from - Sales master
Question is :
How to get row level percentage ? using DAX.
Thanks
@Sean @ankitpatira @KHorseman @Seth_C_Bauer
Solved! Go to Solution.
Thanks @Sean
I got the solution, i did previously but i forgot it now i got it.
anyhow thanks buddy....
% Cal = Divide(Sum(Sales[Sales]), Calculate(Sum(Sales[Sales]),All(Date[month])))
If your sales data is formatted as in the picture you posted - obviously you need to Unpivot first!
Then just use this measure - you basically need a total for each product which you can get with ALLEXCEPT
EDIT: Overall Total for each Product (Denominator)
Measure = DIVIDE ( SUM ( Sales[Sales] ), CALCULATE ( SUM ( Sales[Sales] ), ALLEXCEPT ( Sales, Sales[Product] ) ), 0 )
Hi @Sean
Which i shown in picture that is not my data.
First 1 is which am getting now in Power BI, Second one is i need.
one more info, Product is from different table.
So how are sales and product connected?
Thanks @Sean
I got the solution, i did previously but i forgot it now i got it.
anyhow thanks buddy....
% Cal = Divide(Sum(Sales[Sales]), Calculate(Sum(Sales[Sales]),All(Date[month])))
Okay great!
Measure 2 = DIVIDE ( SUM ( Sales[Sales] ), CALCULATE ( SUM ( Sales[Sales] ), ALL('Calendar') ), 0 )
I have product ID Relationship
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |