Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |