Forum Discussion
Measure or custom column?
Dear All,
I have a table which filters by the following values:
| null |
| x |
| z |
What I want to achieve is a filter which incorporates only the "x" and "y" options, but when you filter for "x" you also filter the table for "null" value. In other words:
| now | desired |
| null | x |
| x | x |
| z | z |
Any suggestion?
Hi gianmarco
You can refer to the following suggestion
Sample data
Slicer data
You can create a measure
Measure = IF(ISFILTERED('Table (2)'[Column1]),IF("X" in VALUES('Table (2)'[Column1]),CALCULATE(SUM('Table'[Value]),FILTER('Table',OR('Table'[Type] in VALUES('Table (2)'[Column1]),[Type]=""))),CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Type] in VALUES('Table (2)'[Column1])))),SUM('Table'[Value]))Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
gianmarco , Create a measure and add visual or visual level filter
countrows(filter(Table, not(isblank(Table[Column])) ))
Column is column having those three values
Dear amitchandak,
maybe I wasn't clear..
I can slice a table for the following row values:
1) null
2) x
3) z
What I want to achieve is a slicer where I can filter for the following options:
1) x & null
2) z
In other words, you can slice for x and z only but when you slice for x you slice for null as well.
Thank you very much
gianmarco
Hi gianmarco
You can refer to the following suggestion
Sample data
Slicer data
You can create a measure
Measure = IF(ISFILTERED('Table (2)'[Column1]),IF("X" in VALUES('Table (2)'[Column1]),CALCULATE(SUM('Table'[Value]),FILTER('Table',OR('Table'[Type] in VALUES('Table (2)'[Column1]),[Type]=""))),CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Type] in VALUES('Table (2)'[Column1])))),SUM('Table'[Value]))Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
