Forum Discussion
Solved
create measures with filters
Hello, I need to create measures using some filter to be able to make some card visuals. here is what I did: I have my date base with all years information, so for making the "sales per year" ...
Thank you lbendlin for your concern.
Hi Marango ,
Based on your description I created simple data:
You can refer to the following measures to get positive and negative totals:
increasing measure = CALCULATE([Measure],FILTER('Table',[Measure]>0))lost measure = CALCULATE([Measure],FILTER('Table',[Measure]<0))Result:
Best Regards,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you lbendlin for your concern.
Hi Marango ,
Based on your description I created simple data:
You can refer to the following measures to get positive and negative totals:
increasing measure = CALCULATE([Measure],FILTER('Table',[Measure]>0))lost measure = CALCULATE([Measure],FILTER('Table',[Measure]<0))
Result:
Best Regards,
Zhu
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.