cancel
Showing results 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

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
Impactful Individual

Try this:

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

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.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

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

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.

Impactful Individual

Try this:

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

Thanks

Frequent Visitor

Thank you so much! it works!

Impactful Individual

Great!!