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 return back True Count and if False Return back False Count

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

????

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)

3 Replies

  • 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)