Count with Filter Measure

[nutyfreshz]

I have 2 Total Clicks measures which calculate current & last month. And i want to count(linelog) which Total clicks(Current) > Total clicks(last month)

Total clicks(current) = TOTALMTD(
COUNT('villa_040322'[lineLog])
,'villa_040322'[clickAt.1].[Date])

Total clicks(lstmonth) = CALCULATE(
COUNT('villa_040322'[lineLog])
,DATEADD('villa_040322'[clickAt.1].[Date],-1,MONTH))

but I used this code and it provides only count(linelog) with no filter.

Measure = CALCULATE(DISTINCTCOUNT('villa_040322'[lineLog]),FILTER('villa_040322','villa_040322'[Total clicks(current)]>='villa_040322'[Total clicks(lstmonth)])

How did I change this code to count no. unique of linelog which Total clicks(current) > Total clicks(lstmonth) in red area in scatterpot.

Thank you.

[v-chenwuz-msft]

Hi @nutyfreshz ,

You can should try to add function like selectedvalue() or max() after "field name >=", like the highlighting code.

Measure = CALCULATE(DISTINCTCOUNT('villa_040322'[lineLog]),FILTER('villa_040322','villa_040322'[Total clicks(current)]>=selectedvalue('villa_040322'[Total clicks(lstmonth)]))

If it does not work, please share your pbix file without sensitive data.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nutyfreshz]

Select value working with Cols but 

[Total clicks(current)] & [Total clicks(lstmonth)]

These are measure not cols. any idea?

Thank you.

[v-chenwuz-msft · Accepted solution]

Hi @nutyfreshz ,

Sorry, i made a mistake. I didn't realize that the [Total clicks(current)] and [Total clicks(lsmonth)] are measure.

If possible, you can change these measures to column, or summarize function to create a template table. Or please share your pbix file without sensitive data. 

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nutyfreshz]

I think I need to create a new table with summarizing and join then filter as column.

I will try, thanks for the solution. I will send pbix file in dm.

Thank you so much.

[nutyfreshz]

Thank you so much, i will try in a second.