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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
fahadkhan
Frequent Visitor

Accumulated value from calculated measure

Hi, 

 

I am making a covid dashboard, I have calculated and segregated data based on their covid status like Cases, Deaths and Recoved, 

 

I have calculated measures using dax like sum of total cases, and change in cases: (new cases - previous cases) based on Date. 

 

now that have calculated the differnce but it isn't accumulated. I might be missing something really small but it has been bugging me for last 4 days. little help needed. thx 🙂 

 

problem.png

Relationship Model:
relationship.png

1 ACCEPTED SOLUTION

@fahadkhan ,

 

Try this:

 

NewMeasure= SUMX(VALUES (Table[Date]), New Cases)

 

Mark this as a solution if I answered your question.

Thanks

View solution in original post

6 REPLIES 6
Greg_Deckler
Super User
Super User

@fahadkhan This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.


Follow on LinkedIn
@ 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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Tanushree_Kapse
Impactful Individual
Impactful Individual

Hi @fahadkhan ,

 

Can you please show what result you are expecting?

 

 

Hi @Tanushree_Kapse ,

Expected Result based on screenshot would be : 

18,895,780

I want calculate sum of all values in the measured column.

 

@fahadkhan ,

 

Try this:

 

NewMeasure= SUMX(VALUES (Table[Date]), New Cases)

 

Mark this as a solution if I answered your question.

Thanks

Thank you so much! it works! 

Great!!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors