Forum Discussion

vijayvizzu's avatar
vijayvizzu
Icon for Helper III rankHelper III
6 years ago

Show MoM variance in line chart

Hi, I have created a Line Chart visual, where X axis is "Month-Year", Y axis is values. I created couple of DAX measures and add those measures into Line Values. This is working fine, it shows me the...
Need Help
  • vijayvizzu's avatar
    vijayvizzu
    Icon for Helper III rankHelper III
    6 years ago

    Anonymous  I am pasting the sample of the code, i had created similar six measures, its basically different mixing composition.

    Thereafter, i created a line chart by adding these 6 measures to see the trend. Now i want to see the variance of each month.

    ABC Blend-XYZ  = 
VAR ABC_XYZ _LLDPE = 
CALCULATE(
    [Avg USD]*0.65,
    FILTER(
        MAIN,
        MAIN[SRC_GRADE]="LLDPE-XYZ -SE ASIA"
    )
)
VAR ABC_XYZ _LDPE = 
CALCULATE(
    [Avg USD]*0.20,
    FILTER(
        MAIN,
        MAIN[SRC_GRADE]="LDPE-XYZ -SE ASIA" 
    )
)
VAR ABC_DEF_LLDPE_C6 = 
CALCULATE(
    [Avg USD]*0.14,
    FILTER(
        MAIN,
        MAIN[SRC_GRADE]="LLDPE C6-DEF-SE ASIA" 
    )
)
RETURN
ABC_XYZ_LLDPE+ABC_XYZ_LDPE+ABC_DEF_LLDPE_C6