Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |