Forum Discussion
Solved
Pareto Chart.. almost there just missing something!?
Hi All, I am very close to achieving a successful pareto chart however i am missing something and it is causing a problem for me. Here is my data: What I am trying to achieve is...
Give these 5 MEASURES a try!
1) TotalAmount MEASURE = CALCULATE ( SUM ( ENGINEER_TABLE[DURATION_HOURS] ), ALLEXCEPT ( ENGINEER_TABLE, ENGINEER_TABLE[ROOM_NUMBER] ) ) 2) OverallTotal MEASURE = CALCULATE ( [TotalAmount MEASURE], ALL ( ENGINEER_TABLE ) ) 3) Room Rank MEASURE = RANKX ( ALL ( ENGINEER_TABLE[ROOM_NUMBER] ), [TotalAmount MEASURE] ) 4) Pareto Value MEASURE = SUMX ( TOPN ( [Room Rank MEASURE], ALL ( ENGINEER_TABLE[ROOM_NUMBER] ), [TotalAmount MEASURE] ), [TotalAmount MEASURE] ) 5) Pareto % MEASURE = DIVIDE ( [Pareto Value MEASURE], [OverallTotal MEASURE], 0 )Here's the result!
Good Luck! :smileyhappy:
Give these 5 MEASURES a try!
1) TotalAmount MEASURE =
CALCULATE (
SUM ( ENGINEER_TABLE[DURATION_HOURS] ),
ALLEXCEPT ( ENGINEER_TABLE, ENGINEER_TABLE[ROOM_NUMBER] )
)
2) OverallTotal MEASURE = CALCULATE ( [TotalAmount MEASURE], ALL ( ENGINEER_TABLE ) )
3) Room Rank MEASURE = RANKX ( ALL ( ENGINEER_TABLE[ROOM_NUMBER] ), [TotalAmount MEASURE] )
4) Pareto Value MEASURE =
SUMX (
TOPN (
[Room Rank MEASURE],
ALL ( ENGINEER_TABLE[ROOM_NUMBER] ),
[TotalAmount MEASURE]
),
[TotalAmount MEASURE]
)
5) Pareto % MEASURE = DIVIDE ( [Pareto Value MEASURE], [OverallTotal MEASURE], 0 )
Here's the result!
Good Luck! :smileyhappy:
Yes! absolute legend cheers Sean :smileyhappy: