Forum Discussion

gianmarco's avatar
gianmarco
Helper IV
3 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

gianmarco's avatar
gianmarco
Helper IV
3 years ago

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.