Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Filtering table with two dax conditions

Hi all,

Im trying to show in this table only the data that have values distintc than ceros or blank taking in consideration the measures: Plan AND Real.... ¿Any thoughts of how can be do it?

Thanks !

Need Help
Tips and Tricks

4 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Anonymous hi

    you could filter out your blank values in the visual filters pane

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

       Hi,

      I think that i need is a filter that consider both dax formulas... if i filter one by one i get a wrong result:

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      az38  I made a DAX that consider the difference between  Plan, Real and PY(prior year) and put it in the filter pane... if this DAX is different than 0 or Blank then will show me a cleaner table and right result.

      Let me know if there is a shorter way to get a solution.

       

      Thanks !

      • az38's avatar
        az38
        Community Champion
        6 years ago

        Anonymous 

        try a meaure like

        ActiveRow = IF(
(NOT(ISBLANK([Plan])) && [Plan]<>0) ||
(NOT(ISBLANK([Real])) && [Real]<>0) ||
(NOT(ISBLANK([PY])) && [PY]<>0),
TRUE(),
FALSE()
)

        then filter in filter pane by this measure

         

        do not hesitate to give a kudo to useful posts and mark solutions as solution