Forum Discussion
Display Chart with Normalized Values
I have this Count of Case ID by Category. But I want to display its normalized values which is equal to the (Sum of CaseID)/`EDU_with_Carpark'*100. How can I get the normalized values?
Can you try this
Normalized Value (%) =
DIVIDE(COUNT('Table'[Case ID]), SELECTEDVALUE('Table'[EDU_with_Carpark])) * 100
4 Replies
Can you try these measures
Total Cases =COUNT('Table'[Case ID])
Total EDU =SUM('Table'[EDU_with_Carpark])
Normalized Value (%) =
DIVIDE([Total Cases],[Total EDU])
* 100
thanks for the prompt reply. I actually do not need to sum the Total EDU, but just the Total Cases divide by the [EDU_with_Carpark]. How should the Normalized Value (%) be modified?
Can you try this
Normalized Value (%) =
DIVIDE(COUNT('Table'[Case ID]), SELECTEDVALUE('Table'[EDU_with_Carpark])) * 100
