Conditional Measure Based on Available Field Values

[billuran]

Hi, Simplistic version; I have 3+ facilities. 2 Of the facilities (FacA & FacB) do not report the data I want to show so I have to show a different measure when they are selected.

Facilities are stored in Table Facilities. Named as FacilitiesName

Measure A if any of the 2 facilities are filtered. 

Measure B if neither of the 2 are selected.

And to note the 2 facilities could be filtered through RLS not by slicer. So whena user logs on they may just have those 2 facilities available or a user could use slicer to filter to those 2 fields.

[billuran]

Thank you. but its not giving me the second measure 

Follow Up Switch = if(isfiltered(Facility[Facility_Name]) && countx(filter(Facility,Facility[Facility_Name] in {"FACA" ,"FACB"}),Facility[Facility_Name])+0>1, [Date Since Worked],[Compliance %])

[v-jingzhang]

Hi @billuran , can you show your expected result with some dummy data? It seems [Date Since Worked] should return date data type and [Compliance %] should return decimal number data type. This may cause a problem because you can set only a format for the conditional measure.

[amitchandak]

@billuran , Try a new measure like

if(isfiltered(Facilities[FacilitiesName]) && countx(filter(Facilities,Facilities[FacilitiesName] in {"FacA" ,"FacB"}),Facilities[FacilitiesName])+0>1, [Measure A],[Measure B])