Showing results for 
Search instead for 
Did you mean: 
aktripathi2506 Helper IV
Helper IV

sum of measure




How can we create the sum of measure. I tried calculate(sum(measure))

giving error.



Super User IV
Super User IV

Re: sum of measure

A measure is really an aggregate value that gets contextually filtered based upon interaction with other visualizations and filters. Therefore, if you put a measure on a card and remove all filters, it has its total maximum value. It shoulds like you want something a little different. Can you provide more information about what you are trying to accomplish, some sample data and expected result?


Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

New Member

Re: sum of measure

I have a similar issue. Trying to calculate the number of support tickets I had open over a month.


In short my table looks like



Name     open date    closed date


I have got my open tickets by counting the count(open date) - count(closed date)


What I would like to acheive is to getting the sum total of these open cases per month, so its easy to see if the number of outstanding cases is increasing or decreasing.



Is there anyway to Sum the number of cases per month?

Helpful resources

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors