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

## measure cumulative total

good noon!

in a table, after VERY LONG calculation, exist measure MeasureTotal (sum of vere many columns ans measures)

and Measure MeasureTotalSum

`MeasureTotalSum=CALCULATE('Table1'[MeasureTotal];ALLSELECTED('Table1'))`

and i`m need the MeasureCumulativeTotal

writing

`MeasureCumulativeTotal =CALCULATE('Table1'[MeasureTotal];										                 FILTER(ALLSELECTED('Table1');'Table1'[MeasureTotal]>=MAXX('Table1';'Table1'[MeasureTotal])`

all, as in the example

how me changed the code to achive standart result?

2 REPLIES 2
Community Champion

@bi_team_ru2 If I understand what you are asking

You have Ranked some category say People based on the Total Net Sales whatever... over some time periods

And you want a Running/Cumulative Total Column BASED ON RANK not dates - to the right of your Total Net per Name Column

What would really help is if you could put Measures on Rows in the Matrix...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10948962-matrix-measures-or-value...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9207006-matrix-collapse-expand-bu...

Post the solution if you find it.

You may have to create another table with the results and then use the - Filter(ALL(TableName), [Rank]<=MAX[Rank])

It won't let me use the Measure

Frequent Visitor

good noon, Sean!

The all measure - the result of a MANY Calculation. and column rank is a next

used this column on a calculation - meaningless

mRank is Measure too, it`s result of the old (incorrect) idea.

then i`m calculate cumulative total based on this measure (Column mRank), on the result i had a column of 1 and variants <= or >=

- don`t change the result

creating the variable MShare, i has non-normalising column of measure Share (multiply koef near 240)

This is a PROBLEM : standart example don`t take a result.

thank for idea and articles. if i`ll solved, nessesary writing result

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

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

Top Solution Authors
Top Kudoed Authors