Power BI Report Filtering Issue while using Measure

[Sabareeshwari]

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

Type	Division	Division Target	Division Target Achieved	Area Target	Area Target Achieved	LG Target	LG Target Achieved
Life Group	Division 4	22	4	10	2	0	0
Life Group	Division 3	21	5	10	4	0	0
Life Group	Division 4	22	4	6	2	0	0
Life Group	Division 1	21	4	5	1	0	0
Life Group	Division 1	21	4	10	1	0	0
Life Group	Division 2	27	4	6	2	0	0
Life Group	Division 3	21	5	10	4	0	0
Life Group	Division 2	27	4	9	1	0	0
Life Group	Division 4	22	4	6	2	0	0
Life Group	Division 2	27	4	7	1	0	0
Life Group	Division 3	21	5	10	4	0	0
Life Group	Division 2	27	4	6	2	0	0
Life Group	Division 3	21	5	10	4	0	0
Life Group	Division 4	22	4	10	2	0	0
Life Group	Division 3	21	5	7	1	0	0
Life Group	Division 1	21	4	6	2	0	0
Life Group	Division 1	21	4	6	2	0	0

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.

[Anonymous]

Hi @Sabareeshwari ,

Could you please tell me where the fields for all three slicers come from? 

It is very helpful for me to test.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sabareeshwari]

I have 3 slicers - Division , Area and LG.

For Division Slicer , i used Division column.

For Area and LG slicers, i used column area and LG Name , which is not given in that above data.  if u need that will share that data.

[Ritaf1983]

Hi @Sabareeshwari 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[Sabareeshwari]

Hi  @Ritaf1983 ,

   I have edited the post with data's . Kindly check and suggest any solution.