Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
aktripathi2506
Helper IV
Helper IV

sum of measure

Hi,

 

 

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

giving error.

 

Thanks.

2 REPLIES 2
Greg_Deckler
Super User
Super User

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?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.