Forum Discussion
Percentage in clustered column
- 6 years ago
Hey mariner84 ,
I created a measure "Assignment Business Partner" using this DAX:
Assignment Business Partner = DIVIDE( CALCULATE( COUNT('Page 1'[Number]) , FILTER(ALL('Page 1'[Level 4]) , 'Page 1'[Level 4] = "Business Partner") ) , CALCULATE( COUNT('Page 1'[Number]) , ALL('Page 1'[Level 4]) ) )adding this measure to the clustered line chart, to the line values
will result in this chart:
To achieve the formatting as a percentage value, you can either multiply by 100 by tweaking the measure, or you can use the formatting of the measure.
Hopefully, this is what you're are looking for.Regards,
Tom
Hey mariner84 ,
I created a measure "Assignment Business Partner" using this DAX:
Assignment Business Partner =
DIVIDE(
CALCULATE(
COUNT('Page 1'[Number])
, FILTER(ALL('Page 1'[Level 4]) , 'Page 1'[Level 4] = "Business Partner")
)
, CALCULATE(
COUNT('Page 1'[Number])
, ALL('Page 1'[Level 4])
)
)
adding this measure to the clustered line chart, to the line values
will result in this chart:
To achieve the formatting as a percentage value, you can either multiply by 100 by tweaking the measure, or you can use the formatting of the measure.
Hopefully, this is what you're are looking for.
Regards,
Tom
TomMartens this is awesome, exactly what I was looking for. Appreciate your quick response.
Thank you,