Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 !
@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
@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 !
@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
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |