cancel
Showing results for
Did you mean: 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 🙂 Relationship Model: 1 ACCEPTED SOLUTION  Super User

Try this:

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

Mark this as a solution if I answered your question.

Thanks

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

@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition    Super User

Can you please show what result you are expecting? Frequent Visitor

Expected Result based on screenshot would be :

18,895,780

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

Try this:

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

Mark this as a solution if I answered your question.

Thanks Frequent Visitor

Thank you so much! it works!  Super User

Great!!   