Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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'))
adding correctly
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
but, instead of the expected result, i had some Unordered number.
how me changed the code to achive standart result?
@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...
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
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
91 | |
86 | |
76 | |
66 |
User | Count |
---|---|
149 | |
117 | |
111 | |
106 | |
95 |