Forum Discussion

CNixon435's avatar
CNixon435
Regular Visitor
3 years ago
Solved

DAX Measure for creating a 100% Stacked Ribbon Chart

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.

 

 

FiscalYearCase Primary MCFC 2 -  Payor DESCHB Gross Charges
FY23Medicaid$5,272,568.90
FY22Medicaid$6,101,612.42
FY22Medicare$15,835,404.85
FY22Managed Medicare$18,292,340.60
FY23Medicare$20,140,686.32
FY23Managed Medicaid$20,442,365.85
FY22Managed Medicaid$20,929,100.95
FY23Managed Medicare$22,104,022.82
DAX
measure
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

     

     

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.