DAX Measure for creating a 100% Stacked Ribbon Chart

[CNixon435]

I am trying to build a measure that will display my "HB Gross Charges" data as a % of total for each fiscal year, similar to the Stacked Bar Chart below.

I found this post that is very similar to what I am trying to attempt. However, the hitch is that my "HB Gross Charges" field is a measure, so I am not sure how to set up the correct Variable to be able to do this. 

Doing my best to learn DAX, but this one is over my head.

FiscalYear	Case Primary MCFC 2 -  Payor DESC	HB Gross Charges
FY23	Medicaid	$5,272,568.90
FY22	Medicaid	$6,101,612.42
FY22	Medicare	$15,835,404.85
FY22	Managed Medicare	$18,292,340.60
FY23	Medicare	$20,140,686.32
FY23	Managed Medicaid	$20,442,365.85
FY22	Managed Medicaid	$20,929,100.95
FY23	Managed Medicare	$22,104,022.82

[Anonymous · Accepted solution]

Hi @CNixon435 ,

Please have a try.

HB Gross Charges % of Total = 
DIVIDE([HB Gross Charges], CALCULATE([HB Gross Charges], ALLSELECTED()))

Or try this .

HB Gross Charges % of Total =
VAR TotalCharges =
    CALCULATE ( [HB Gross Charges], ALL ( 'Date'[Fiscal Year] ) )
RETURN
    DIVIDE ( [HB Gross Charges], TotalCharges )

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.