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

Select value working with Cols but 

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

These are measure not cols. any idea?

 

Thank you.

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    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.

    • nutyfreshz's avatar
      nutyfreshz
      Frequent Visitor
      4 years ago

      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.