Measure or custom column?

[gianmarco]

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?

[amitchandak]

@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

[gianmarco]

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

[v-xinruzhu-msft · Accepted solution]

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.