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('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.

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.

5 Replies

  • 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.

    • 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.