Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
141 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
73 | |
66 | |
60 |