Forum Discussion

LyonsBI_BRL's avatar
LyonsBI_BRL
Helper III
5 years ago
Solved

Creating Calcuation Groups Help

I'm attempting to create a calcuation group for my measure to help clean up the number of measures that I do have. The calcuation group would countain four different measures through the use of the Tabular Editor program.

  • Count number of YES responses per technology
  • Count number of YES responses per technology
  • Count number of BLANK responses per technology
  • Overall percentage of YES answers

# of Yes calculation

 

CALCULATE(
    COUNTA('Operational'[Column1.Minecraft]),
    'Operational'[Column1.Minecraft]
        IN { "Yes" }
)

 

 

# of No Calculation

 

CALCULATE(
    COUNTA('Operational'[Column1.Minecraft]),
    'Operational'[Column1.Minecraft]
        IN { "Yes" }
)

 

 

# of Blank Calculation

 

CALCULATE(
    COUNTBLANK('Operational'[Column1.Minecraft])
)

 

I'd assume for # of Blanks it'd be something ot the effect of Calculate( SelectedMeasure() CountBlank()) or am I incorrect on this?

 

Any assistance would be greatly appreciated as right now the number of measures is quite a bit here.

 

Thanks!

  • You could use IN {""} or ="" or ISBLANK('Operational'[Column.Minecraft]) in your CALCULATE


    Pat

     

3 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee

    You could use IN {""} or ="" or ISBLANK('Operational'[Column.Minecraft]) in your CALCULATE


    Pat

     

    • LyonsBI_BRL's avatar
      LyonsBI_BRL
      Helper III

      Thanks mahoneypat 

      Would it look like this then within Tabular Editor for the one calculation items?

      IN{""} or ISBLANK('Operational'[Column.Minecraft]) 

      Thanks!

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee

    Sorry I didn't clarify.  It would look just like your # of Yes/No calculations; i just provided the part that would change.

    Pat