Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
newbie9
Helper I
Helper I

selected value for multiple select

Hi All,

what I need is

if no region is selected in the region slicer then the measure need to show US region value for selected player

i.e for player A

if region is not selected then measure should show 100 (US region) if not then it should show max of selected regions

 

I can give if condition with selectedvalue() but it will not work when 2 items are selected 

how can I overcome this?

 

 

Measure = SWITCH(
    SELECTEDVALUE(Table1[player]),
    "a",CALCULATE(MAX(Table1[value]),Table1[player]="a"),
    "b",CALCULATE(MAX(Table1[value]),Table1[player]="b"),
    "c",CALCULATE(MAX(Table1[value]),Table1[player]="c")
)

 

playerregionvalue
aindia300
auk200
aus100
bindia400
buk190
bus150
cindia900
cuk170
cus250
1 ACCEPTED SOLUTION

@newbie9 , Use this measure that will give result on the basis of whether region is selected or not.

 

Measure 4 = IF(ISFILTERED(Table1[region]) , SWITCH(
    SELECTEDVALUE(Table1[player]),
    "a",CALCULATE(MAX(Table1[value]),Table1[player]="a"),
    "b",CALCULATE(MAX(Table1[value]),Table1[player]="b"),
    "c",CALCULATE(MAX(Table1[value]),Table1[player]="c"))
, CALCULATE(MAX(Table1[value]), Table1[region] = "us") )

View solution in original post

4 REPLIES 4
ChiragGarg2512
Super User
Super User

@newbie9 , Is this what the requirement is?

ChiragGarg2512_0-1695635627568.png

ChiragGarg2512_1-1695635672110.png

 

 

 

@ChiragGarg2512 

 

yes that's it 

when no region is selected for A then 100

if all regions are selected then 300

if us & uk is selected then 200

if uk & India is selected then 300

if uk alone then 200

if us alone then 100

 

no region is selected it should give show value of US region if not MAX of selected regions

@newbie9 , Use this measure that will give result on the basis of whether region is selected or not.

 

Measure 4 = IF(ISFILTERED(Table1[region]) , SWITCH(
    SELECTEDVALUE(Table1[player]),
    "a",CALCULATE(MAX(Table1[value]),Table1[player]="a"),
    "b",CALCULATE(MAX(Table1[value]),Table1[player]="b"),
    "c",CALCULATE(MAX(Table1[value]),Table1[player]="c"))
, CALCULATE(MAX(Table1[value]), Table1[region] = "us") )

thanks @ChiragGarg2512  

now it's working as expected

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.