Calculate percentage of Revenue by Month and different type of Accounts

[WorkHard]

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

[harshnathani · Accepted solution]

Hello @WorkHard ,

Create 3 measures

Sales = SUM('Table'[USD])

REV - CALCULATE([Sales], 'Table'[Account] - "Revenue")

Percentage: DIVIDE([Sales],[REV])

Best regards
Harsh Nathani
Did I answer your question? Mark my position as a solution! Appreciate with a Kudos!! (Click the Thumbs button above)

[harshnathani]

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)

[WorkHard]

Added underlying data in OP. Thank you