Forum Discussion
Solved
Measure to DIVIDE two columns with filtered values
Hey everyone, I'm struggling to understand how to create a measure for a gauge/KPI visual for my report, having an execution ID (snag on product) and case name (production units inspected). I...
Hi tmyasoutov ,
maybe so
Measure = COALESCE(DIVIDE(COUNT(Table[Execution ID]),DISTINCTCOUNT('Table'[Case Name])),0)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mangaus1111
Solution Sage
Solution SageHi tmyasoutov ,
maybe so
Measure = COALESCE(DIVIDE(COUNT(Table[Execution ID]),DISTINCTCOUNT('Table'[Case Name])),0)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes, just checked, it works! Thank you mangaus1111 !