measure to calculate the total and display it on the single bar chart

[Cardi0z]

Category	PIR1	PIR2	1st week	Total MTD	Miss Output	MTD	Full Mth	PIR Rev
Liquid	135,000	129,000	24,000	24,000	105,000	18.60%	100.00%	-4.44%
Solid	123,000	123,500	24,000	24,000	99,500	19.43%	100.00%	0.41%

that is my table, I wanto to create bar chart base on value of

1. Y axis : Total MTD liquid/PIR2 liquid, Total MTD solid/PIR2 solid, Total MTD (liquid+solid)/Total PIR2 (solid+liquid)
2. Y axis : (Total MTD liquid+Miss Output liquid)/PIR2 Liquid, (Total MTD solid+Miss Output solid)/PIR2 solid, (Total MTD liquid&solid + Miss Output liquid&solid)/PIR2 Liquid&solid,

please help me how to do that

thank you

[Cardi0z]

Dear @Sahir_Maharaj , @rajendraongole1 

from the data source above, is it possible to create a chart like the screenshot below? how to calculate it?

[Sahir_Maharaj]

Hello @Cardi0z,

Can you please try the following:

1. Total MTD / PIR2

MTD_PIR2_Liquid = 
DIVIDE(
    SUMX(FILTER(YourTable, YourTable[Category] = "Liquid"), YourTable[Total MTD]),
    SUMX(FILTER(YourTable, YourTable[Category] = "Liquid"), YourTable[PIR2])
)

MTD_PIR2_Solid = 
DIVIDE(
    SUMX(FILTER(YourTable, YourTable[Category] = "Solid"), YourTable[Total MTD]),
    SUMX(FILTER(YourTable, YourTable[Category] = "Solid"), YourTable[PIR2])
)

MTD_PIR2_Total = 
DIVIDE(
    SUMX(YourTable, YourTable[Total MTD]),
    SUMX(YourTable, YourTable[PIR2])
)

2. (Total MTD + Miss Output) / PIR2

MTD_MissOutput_PIR2_Liquid = 
DIVIDE(
    SUMX(FILTER(YourTable, YourTable[Category] = "Liquid"), YourTable[Total MTD] + YourTable[Miss Output]),
    SUMX(FILTER(YourTable, YourTable[Category] = "Liquid"), YourTable[PIR2])
)

MTD_MissOutput_PIR2_Solid = 
DIVIDE(
    SUMX(FILTER(YourTable, YourTable[Category] = "Solid"), YourTable[Total MTD] + YourTable[Miss Output]),
    SUMX(FILTER(YourTable, YourTable[Category] = "Solid"), YourTable[PIR2])
)

MTD_MissOutput_PIR2_Total = 
DIVIDE(
    SUMX(YourTable, YourTable[Total MTD] + YourTable[Miss Output]),
    SUMX(YourTable, YourTable[PIR2])
)

3. Create a new table

MeasureTable = 
UNION(
    SELECTCOLUMNS(
        FILTER(YourTable, YourTable[Category] = "Liquid"),
        "Category", "Liquid",
        "MTD_PIR2", [MTD_PIR2_Liquid],
        "MTD_MissOutput_PIR2", [MTD_MissOutput_PIR2_Liquid]
    ),
    SELECTCOLUMNS(
        FILTER(YourTable, YourTable[Category] = "Solid"),
        "Category", "Solid",
        "MTD_PIR2", [MTD_PIR2_Solid],
        "MTD_MissOutput_PIR2", [MTD_MissOutput_PIR2_Solid]
    ),
    SELECTCOLUMNS(
        YourTable,
        "Category", "Total",
        "MTD_PIR2", [MTD_PIR2_Total],
        "MTD_MissOutput_PIR2", [MTD_MissOutput_PIR2_Total]
    )
)

[Cardi0z]

Dear @Sahir_Maharaj 

why does the total value have 2 rows?

cc :
@Anonymous 
@Anonymous 
@Anonymous 
@Anonymous