True and False Filter

[Anonymous]

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

????

[amitchandak · Accepted solution]

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

[Anonymous]

Hi Amit - Could u have a look at this its off by one row....i.e. the end results need to shift up one row....cannot work it out
https://community.powerbi.com/t5/Desktop/Measure-to-start-from-a-specific-date/m-p/1941439#M739034

[Anonymous]

Thanks Amit