Forum Discussion

tmyasoutov's avatar
tmyasoutov
Frequent Visitor
3 years ago
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...
Need Help
  • mangaus1111's avatar
    mangaus1111
    3 years ago

    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's avatar
mangaus1111
Icon for Solution Sage rankSolution Sage
3 years ago

Hi tmyasoutov ,

 

try with this

Measure = DIVIDE(COUNT(Table[Execution ID]),DISTINCTCOUNT('Table'[Case Name]))
 
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  • tmyasoutov's avatar
    tmyasoutov
    Frequent Visitor
    3 years ago

    Understood, thank you mangaus1111 ! Any idea how to correctly add IF(ISBLANK) = 0 within this measure?

    • mangaus1111's avatar
      mangaus1111
      Icon for Solution Sage rankSolution Sage
      3 years ago

      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.

                                      

      • tmyasoutov's avatar
        tmyasoutov
        Frequent Visitor
        3 years ago

        Yes, just checked, it works! Thank you mangaus1111 !