Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

undefined

Can I create a sum measure from a measure? I have calculated the positive values from all values in the table visual with visual level filter but i want sum of positive values in card also. Is this ...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

To Calculate a filter over measure you need group it some level and then filter. Typically Values, addcolumns or summarize are used to do that.

 

Please refer to this post, there are few solutions

https://community.powerbi.com/t5/Desktop/Filter-by-the-sum-of-a-column-where-value-of-another-column/td-p/889200

 

CALCULATE(COUNTX(filter(SUMMARIZE(Sales,'Date'[date],"s1",SUM(Sales[Sales Amount])),[s1]>120),[s1])

'

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601