Forum Discussion
Supress Cell Count Error in Stacked Bar Chart
give this a try?
Supress_Cell =
VAR qst =
SELECTEDVALUE ( [question] )
VAR result =
CALCULATE (
DISTINCTCOUNT ( 'DataTable'[form_submission] ),
'DataTable'[question] = qst,
REMOVEFILTERS ( 'DataTable'[Likert scale] )
)
RETURN
IF ( result >= 5, 1 )
you can then use this as a flag on your visual, place on the filter area of the visual and select 1
Community Championgive this a try?
Supress_Cell =
VAR qst =
SELECTEDVALUE ( [question] )
VAR result =
CALCULATE (
DISTINCTCOUNT ( 'DataTable'[form_submission] ),
'DataTable'[question] = qst,
REMOVEFILTERS ( 'DataTable'[Likert scale] )
)
RETURN
IF ( result >= 5, 1 )
you can then use this as a flag on your visual, place on the filter area of the visual and select 1
This worked perfectly! Thank you so much! I am very new to this, if you have time I'd love to get a breakdown of what you did here? Thanks again 🙂