Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Remove blank values from measure

Hi,

I have a Line and Stacked Column chart where I want to filter out blank values based on one of the measure values from the chart. Is there a way to remove blank values without applying Visual Level filter. Currently I am using Visual level filter which has a high performance issue. The visual takes so much time to load with the visual level filters. 

 

Regards,

Priyanga

Need Help

1 Reply

  • niteshtrehan89's avatar
    niteshtrehan89
    Icon for Helper III rankHelper III
    5 years ago

    Hi Priyanga,

     

    Can you try the measure

    measure= calculate(sum(sales),filter(table,not(isblank(table(column)))))