Forum Discussion

nutyfreshz's avatar
nutyfreshz
Frequent Visitor
4 years ago
Solved

Count with Filter Measure

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('vill...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    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.

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

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's avatar
nutyfreshz
Frequent Visitor
4 years ago

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