Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

True and False Filter

Hi Expert   I have the following measure which counts the number of either True or False rows. How could i write the measure based on the Slicer....so if true was selected - based on selected value...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , a measure like 

    Measure = Countrows(Filter(App Forms[IsEvent] = selectedvalue(App Forms[IsEvent] ))) +0


     

    or

    Measure =
    VAR _Tru = Countrows(Filter(App Forms[IsEvent] = "TRUE")) +0
    VAR _FAL = Countrows(Filter(App Forms[IsEvent] = "FALSE") +0

    return

    if(selectedvalues(filter[filter]) = "True", _Try, __FAL)

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , a measure like 

Measure = Countrows(Filter(App Forms[IsEvent] = selectedvalue(App Forms[IsEvent] ))) +0


 

or

Measure =
VAR _Tru = Countrows(Filter(App Forms[IsEvent] = "TRUE")) +0
VAR _FAL = Countrows(Filter(App Forms[IsEvent] = "FALSE") +0

return

if(selectedvalues(filter[filter]) = "True", _Try, __FAL)