cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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!:
Mastering Power BI 2nd Edition

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!!

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors