Create a measure to restrict to do summation when only two fields in the Slicer are selected.

[SantoshKumar]

I have below table data :

 Area     Region    Role            Type         Year   Offshore  Onshore  Total

Area1	Region1	Developer	Non-ATC	2022	1	1	2
Area1	Region1	Tester	ATC	2022	15	1	16
Area2	Region1	Tester	ATC	2022	3	0	3
Area2	Region1	Tester	Non-ATC	2022	1	0	1
Area2	Region2	Developer	Non-ATC	2022	0	2	2
Area2	Region2	Tester	ATC	2022	13	0	13
Area3	Region1	Tester	ATC	2022	0	5	5
Area3	Region3	Tester	ATC	2022	4	0	4
Area3	Region2	Developer	Non-ATC	2022	0	1	1
Area3	Region2	Tester	ATC	2022	0	5	5
Area3	Region4	Tester	ATC	2022	0	5	5

I want to apply a condition only when i select a selection such as :
Area= Area 3 and Region = Region2 & Region4 => then the data should show only values of Region2 instead of SumofRegion2& Region4.

for  else statement, it should work as normal.

Below is the snapshot of the visualization:

Instead of 10 it should show only 5 when Region2 and Region4 are selected.

[Greg_Deckler]

@SantoshKumar Is it specifically for the case of Region2 and Region4 or is the logic if 2 are selected then display the minimum one or ?

[SantoshKumar]

@Greg_Deckler , I need to apply condition only :
when my selection is 1) Area as Area3 and 2) when i select region2 and Region4 together then it should display value of (Area3 ->Region2 only)

and for rest of them, it should be normal expected values only.

[Greg_Deckler · Accepted solution]

@SantoshKumar Maybe try constructing measures for Offshore, Onshore and Total like this:

Onshore Measure = 
    VAR __Area = SELECTEDVALUE('Table'[Area])
    VAR __Regions = DISTINCT('Table'[Region])
RETURN
    IF(
        __Area = "Area3" && "Region2" IN __Regions && "Region4" IN __Regions,
        SUMX(FILTER('Table',[Region] = "Region2"),[Onshore]),
        SUM('Table'[Onshore])
    )

[SantoshKumar]

@Greg_Deckler Its worked for me. Thanks for the Help.