Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power BI Report Filtering Issue while using Measure

i have a PowerBI Report which have a value like the below Image.

TypeDivisionDivision TargetDivision Target AchievedArea TargetArea Target AchievedLG TargetLG Target Achieved
Life GroupDivision 422410200
Life GroupDivision 321510400
Life GroupDivision 42246200
Life GroupDivision 12145100
Life GroupDivision 121410100
Life GroupDivision 22746200
Life GroupDivision 321510400
Life GroupDivision 22749100
Life GroupDivision 42246200
Life GroupDivision 22747100
Life GroupDivision 321510400
Life GroupDivision 22746200
Life GroupDivision 321510400
Life GroupDivision 422410200
Life GroupDivision 32157100
Life GroupDivision 12146200
Life GroupDivision 12146200

i have calculated Division Target and Division Achieved with following Measures:

DivisionTarget = SUMX(
    SUMMARIZE(
        Target,
        Target[Division],
        "DivTarget", MAX(Target[Division Target])
    ),
    [DivTarget]
)
DivisionAchieved = SUMX(
    SUMMARIZE(
        Target,
        Target[Division],
        "DivTargetAch", MAX(Target[Division Target Achieved])
    ),
    [DivTargetAch]
)
 
Using Clustered Column Chart we have achieved showing Division Target and Division Achieved. in X-axis kept Type and in
Y-Axis kept Division Target and Division Achieved.
 
It results show like below Chart in PowerBI Report.

we used 3 slicers for filters like Division , Area and LifeGroup.

 

If we Filter Division , values in the chart modified based on the selection. But if we filter Area and LifeGroup there is no change in the Chart Visual. 

 

Kindly suggest Solution to filter area and LifeGroup , based on that filter selection chart visual have to modify.