Show Value as % of Column Total in stacked column chart

[Anonymous]

Hi,

How do I create a measure to calculate the % of Column Total for the Column y-axis in a stacked column chart but I want to exclude the ">18 Mth" from the stacked column chart. The chart data label should show value as per the following table with the country in x-axis:

[Anonymous]

Appreciate your sharing. I managed to figure out a much simpler measure that works which I shared below:

Aging INV Value =

VAR CurrMth = MONTH(MAX('Calendar'[Date]))

VAR CurrYr = YEAR(MAX('Calendar'[Date]))

Return

    CALCULATE(SUM('INV Aging'[Inventory Value]), MONTH('Calendar'[Date]) = CurrMth, YEAR('Calendar'[Date]) = CurrYr)

Aging % of Total =

VAR ALLAging = Calculate('1_Measures'[Aging INV Value], ALL('Aging Days'))

Return

       DIVIDE('1_Measures'[Aging INV Value], ALLAging)

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your datamodel.

Ratio: = 
VAR _allcount =
    COUNTROWS ( Data )
VAR _categorycount =
    COUNTROWS (
        FILTER (
            Data,
            Data[Category] >= MIN ( Category[Min] )
                && Data[Category] <= MAX ( Category[Max] )
        )
    )
RETURN
    DIVIDE ( _categorycount, _allcount )

Ratio expected result: = 
SUMX(
FILTER(
ADDCOLUMNS( Category, "@ratio", [Ratio:]), Category[Max] <= 18 ), [@ratio] )