Row level percentages in a matrix visual

[Lukaszj]

I have a table featuring data similar to the sample data in screenshot below. I am wondering if it is possible to create a measure that will display the percentage of total dollars in each Category (A or B), i.e. for Bob the goal would be to see that 73.97% of his pay was in category A (2541/3435 * 100).

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Expected result measure: =
VAR _pay =
    SUM ( Sales[Pay] )
VAR _totalpay =
    CALCULATE ( SUM ( Sales[Pay] ), ALL ( Category[Category] ) )
RETURN
    DIVIDE ( _pay, _totalpay )

[Lukaszj]

Thank you! I was able to get this to work on my file with the real business information on it. However, I was able to make it to work without splitting up the table into many separate ones like you show in your relationship diagram. Is there any reason you chose to do that?

[Jihwan_Kim]

Hi,

Thank you for your message. I tried to create a "Star Schema Data model" in Power BI.