Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I 've got problem with creating cumulative line chart. The variable has nominal values between 0 and 10 and I want to create a chart with share of nominal values in such a pattern:
if value equals 0 this observation is only in 0,
if value equals 1 this observation is in 1 and 0,
if value equals 2 this observation is in 2, 1 and 0,
... etc
if value equals 10 this observation is in 10,9,8,7,6,5,4,3,2,1,0 (in all)
The following plot contains shares of distinct values, I want to accumulate values according to described pattern.
Hi @Anonymous ,
Do you want to calculate cumulative share of observation? If so, you can reference my sample to modify yours.
Measure = CALCULATE(SUM(Table1[share]),FILTER(ALL(Table1),Table1[values] <= MAX(Table1[values])))
If I understand incorrectly , please post some sample data and excepted output. Then we can help you as soon as possible.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Almost good, but in opposite way 🙂
In zero's should be all values - from 0 to 10,
in 1 all except 0,
in 2 all except 0 and 1
...
in 9 only 9 and 10
and in 10 only ten's
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |