DAX Query

[GuestUser]

Hi Team,

We have two tables :

Fact Table -  Sales Amount Column

Dimesnion Table -    Category Column

Below report format is needed :

CAtegory  Expense Amount  Expense %
COGS             100
ABC1              200
ABC2              300

Expense Amount = Fact(Amount) where cateogory = 'COGS' || category = ABC
Expense % = Expense Amount/ Fact(Amount) where category = Sales

I can see the expense amount correctly but expense % is showing blank since Sales Category is not used in the report
We have filtered this report to not show the sales category

But in expense % calculation , we need the expenses to be calculated on basis of Sales

Any suggestions pls on Expense % formula

[mwegener · Accepted solution]

Hi @GuestUser ,

try this.

PBIX

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.