DAX Measure for creating a 100% Stacked Ribbon Chart

CNixon435 — Wed, 16 Aug 2023 23:02:01 GMT

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

Re: DAX Measure for creating a 100% Stacked Ribbon Chart

Anonymous — Fri, 18 Aug 2023 01:31:42 GMT

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.

topic DAX Measure for creating a 100% Stacked Ribbon Chart in DAX Commands and Tips

DAX Measure for creating a 100% Stacked Ribbon Chart

Re: DAX Measure for creating a 100% Stacked Ribbon Chart