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.
I have a table displaying amounts in a matrix with Months as Columns and different accounts as Rows.
I am trying to calculate the percentage of revenue per account per month using a matrix visual.
The below formula works and displaying the TOTAL percentage of revenue per account correctly but the breakdown by month is calculating based on the TOTAL revenue instead of calculating dynamically per month.
What am I missing?
Total Value = SUM ( Data[Value] )
Total Revenue = CALCULATE( [Total Value], FILTER ( ALLSELECTED( Chart ), Chart[Level 1] = "Revenue" ) )
% of Revenue = DIVIDE( [Total Value], [Total Revenue], 0 )
Here's some sample data:
Date | GL | USD | Account |
1/1/2020 | 1 | 10 | Sales |
2/1/2020 | 2 | 20 | Sales |
3/1/2020 | 3 | 30 | Sales |
1/1/2020 | 41 | 40 | Revenue |
2/1/2020 | 42 | 200 | Revenue |
3/1/2020 | 43 | 60 | Revenue |
Solved! Go to Solution.
Hello @WorkHard ,
Create 3 measures
Sales = SUM('Table'[USD])
Hello @WorkHard ,
Create 3 measures
Sales = SUM('Table'[USD])
Hi @WorkHard
Please share data in text format and in a tabular way.
,Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Added underlying data in OP. Thank you
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |