Creating a measure with a filter

[jonnyA]

I have a Field that is counting Visits where I can filter specific Visits using "Visit is 1" or "Visit is 0".

How can I create measure that has the filter "Visit is 1" built in?  This way I wont have to use a filter.

Thank you!

[Anonymous]

Hi @jonnyA ,

You could use filter function.

https://docs.microsoft.com/en-us/dax/filter-functions-dax 

Measure = calculate(countrows('table'),filter(allselected('table'),[Visits] = "Visit is 1"))

I'd like to suggest you to create a independent slicer.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers 

slicer = distinct('table'[visits])

Then modify the measure as bleow:

Measure = calculate(countrows('table'),filter(allselected('table'),[Visits] = selectedvalue('slicer'[visits])))

So that you don't have to create multiple measures for different [visits].

Best Regards,

Jay

[MFelix]

Hi @jonnyA ,

You can create the following measure:

Visit 1 = CALCULATE(COUNT(Table[Visit]), Table[Visit] = "Visit is 1")

[jonnyA · Accepted solution]

Thank you for your time and effort!

Here is the formula for visits ...

CALCULATE(

DISTINCTCOUNT(Dataset[Voucher_Number]),

[IsVisit] = 1)