Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I currently have a measure for a pareto chart:
however I was hoping to get this in % form i.e. rather than a range of 1-1200 for example is it possible to get this as a 0-100% range?
Solved! Go to Solution.
@Anonymous , Try like
Cumul Events =
VAR thisdate =
MAX ( 'Enhanced line list'[Event Date] )
RETURN
divide(
CALCULATE (
[Count],
ALL ( 'Enhanced line list'[Event Date] ),
'Enhanced line list'[Event Date] <= thisdate
) ,
CALCULATE (
[Count],
ALL ( 'Enhanced line list'[Event Date] )
)
)
or
Cumul Events =
VAR thisdate =
MAX ( 'Enhanced line list'[Event Date] )
RETURN
divide(
CALCULATE (
[Count],
ALL ( 'Enhanced line list'),
'Enhanced line list'[Event Date] <= thisdate
) ,
CALCULATE (
[Count],
ALL ( 'Enhanced line list' )
)
)
@Anonymous , Try like
Cumul Events =
VAR thisdate =
MAX ( 'Enhanced line list'[Event Date] )
RETURN
divide(
CALCULATE (
[Count],
ALL ( 'Enhanced line list'[Event Date] ),
'Enhanced line list'[Event Date] <= thisdate
) ,
CALCULATE (
[Count],
ALL ( 'Enhanced line list'[Event Date] )
)
)
or
Cumul Events =
VAR thisdate =
MAX ( 'Enhanced line list'[Event Date] )
RETURN
divide(
CALCULATE (
[Count],
ALL ( 'Enhanced line list'),
'Enhanced line list'[Event Date] <= thisdate
) ,
CALCULATE (
[Count],
ALL ( 'Enhanced line list' )
)
)
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |