Forum Discussion

jamesclark458's avatar
jamesclark458
Frequent Visitor
3 years ago
Solved

Exclude NULL values from VAR Measures

Hi folks,   I have a series of visuals that calculate a Net Promoter Score style output.    I was given elsewhere in this forum the below measure, you will note that at the bottom that NULL value...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi jamesclark458 ,

    Please try to filter the table that you want to exclude null value, then use this new table to calculate, like below dax formula, please refer:

    var tmp= filter(All("Table Name"),[ColumnName]<>"null")

     

    Best regards,
    Community Support Team_ Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi jamesclark458 ,

Please try to filter the table that you want to exclude null value, then use this new table to calculate, like below dax formula, please refer:

var tmp= filter(All("Table Name"),[ColumnName]<>"null")

 

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.