Filtering table with two dax conditions

[Anonymous]

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 !

[az38]

@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]

@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]

@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

[Anonymous]

 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: