Forum Discussion
Helper IHow to Remove blank data in matrix table
Sugumaran31 for sure.
so i think in the return of the growth % measure , you could write something like this .
growth % =
var numerator = [growth]
var denominator = [sales PYD]
returnswitch (
true() ,
isblank( numerator) , blank() , divide ( numerator , denominator ) )
let me know if this helps.
Community Championyou have multiple approach
you can filter from the filter pane on the visual level, where the measure growth is not blank () .
another approach would be .
using a switch( ) in the code of the growth %,
and returning blank() if growth is blank() .
let me know if this helps.
Helper IDaniel29195 But the filter pane on the visual is not working how do I use the switch function can you give me an example
- Daniel29195
Sugumaran31 for sure.
so i think in the return of the growth % measure , you could write something like this .
growth % =
var numerator = [growth]
var denominator = [sales PYD]
returnswitch (
true() ,
isblank( numerator) , blank() , divide ( numerator , denominator ) )
let me know if this helps.