Forum Discussion
Sugumaran31
Helper I
Helper IHow to Remove blank data in matrix table
How to Remove blank data in matrix table. I need only show the value please refer to the image below
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.
Sugumaran31Helper I
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
Community Champion
Community ChampionSugumaran31 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]
return
switch (
true() ,
isblank( numerator) , blank() , divide ( numerator , denominator ) )
let me know if this helps.