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 ,

 

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.