Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Percentage = DIVIDE(COUNT('Raw_Data'[OTD Status]),CALCULATE(COUNT('Raw_Data'[OTD Status]),ALL(Raw_Data)))
Please let me know if this does not make sense. Thank you so much
Solved! Go to Solution.
Hi @Anonymous ,
Not really sure if I understand your request but in your measure you are refering ALL so this will consider every line in your data model (on time, late and other) try to redo your measure to:
Percentage =
DIVIDE (
COUNT ( 'Raw_Data'[OTD Status] ),
CALCULATE (
COUNT ( 'Raw_Data'[OTD Status] ),
FILTER ( ALL ( Raw_Data ), NOT ( 'Raw_Data'[OTD Status] IN { "Other" } ) )
)
)
Basically I'm picking up the all the values except for the Other and making the division based on that.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous ,
Not really sure if I understand your request but in your measure you are refering ALL so this will consider every line in your data model (on time, late and other) try to redo your measure to:
Percentage =
DIVIDE (
COUNT ( 'Raw_Data'[OTD Status] ),
CALCULATE (
COUNT ( 'Raw_Data'[OTD Status] ),
FILTER ( ALL ( Raw_Data ), NOT ( 'Raw_Data'[OTD Status] IN { "Other" } ) )
)
)
Basically I'm picking up the all the values except for the Other and making the division based on that.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you so much. Actually this works well for me.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |