undefined

[Anonymous]

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 possible to get this ? 

[amitchandak]

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

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-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[rajulshah]

Hello @Anonymous,

I didn't really understand what is required. But maybe the following link can help you.
https://community.powerbi.com/t5/Desktop/Sum-of-values-in-a-measure-with-divide-measure/m-p/296768#M130947

Or if you provide sample data and expected results, I could help you in a better way.

[Anonymous]

Hi @Anonymous ,

If you want to get the sum result of your measure in a card, I think you just need to pull your measure into the card, that will be fine.

If you want to use measure to do the positive calculation, you can try below measure:

positive measure = calculate([your_measure],[your_measure] >0)

Please try.

Aiolos Zhao

[Anonymous]

Thanks for your reply @Aiolos Zhao

I am getting this error.(A function CALCULATE has been used in a true/false expression that is used as a table filter expression. This is not allowed ) 😞

[Anonymous]

Hi @Anonymous ,

Sorry, please try below measure, I make it in my report.

CALCULATE([your_measure],FILTER('your_table',[your_measure] > 0))

Aiolos Zhao