Forum Discussion
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
- mahoneypatMicrosoft Employee
You could use IN {""} or ="" or ISBLANK('Operational'[Column.Minecraft]) in your CALCULATE
Pat- LyonsBI_BRLHelper III
Thanks mahoneypat
Would it look like this then within Tabular Editor for the one calculation items?
IN{""} or ISBLANK('Operational'[Column.Minecraft])Thanks!
- mahoneypatMicrosoft 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