Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have a clustered column showing total requests by date, but I'd now also like to show what percentage of the requests came from a certain criteria.
I have a sample pbix here
If anyone is able to help, that would be appreciated.
Thank you
Solved! Go to Solution.
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,
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |