Forum Discussion

JimJim's avatar
JimJim
Icon for Responsive Resident rankResponsive Resident
6 years ago
Solved

Measure overrides slicer selection

Hi Guys,   I have the following measure:   Is Compliant = SWITCH(SELECTEDVALUE('Timesheet Compliance'[IsCompliant]),1,"✓","☓")   The problem I have is the measure returns an "☓" for every othe...
Need Help
  • JimJim's avatar
    JimJim
    6 years ago

     Guys, I'm sorry but I completely complicated this whole thing. I simply had to remove the ELSE part of the measure. My new measure is:

     

    Is Compliant = SWITCH(SELECTEDVALUE('Timesheet Compliance'[IsCompliant]),1,"✓",0,"☓")
     
    I failed to tell you that the only values in IsCompliant are 1 and 0, if I had told you this I'm sure someone would have gave me the correct answer straight away.
     
    Thanks to everyone who contributed.
JimJim's avatar
JimJim
Icon for Responsive Resident rankResponsive Resident
6 years ago

 Guys, I'm sorry but I completely complicated this whole thing. I simply had to remove the ELSE part of the measure. My new measure is:

 

Is Compliant = SWITCH(SELECTEDVALUE('Timesheet Compliance'[IsCompliant]),1,"✓",0,"☓")
 
I failed to tell you that the only values in IsCompliant are 1 and 0, if I had told you this I'm sure someone would have gave me the correct answer straight away.
 
Thanks to everyone who contributed.
  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi JimJim ,

     

    Glad to hear that you have resolved your problem. Thank you for sharing this wonderful solution, would you please kindly mark your shared solution as an answer so that it can benefit more users?  If you have any other questions about this scenario, please kindly ask here and we will try to resolve it.


    Best regards,