Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
spenceratchison
Regular Visitor

Dax to Ignore Specific Slicer

Hello,

I am attempting to create a measure that is responsive to a specific slicer, but not another. I will include screenshots to illustrate my issue.

spenceratchison_0-1666742326343.png
As you can see, this is functioning properly as the card is displaying the corresponding defensive value in the table for the slicer selection. I will now include a screenshot when a team is selected in the other slicer.

spenceratchison_1-1666742420178.png

The value goes to 0 whenever I select a team from both slicers and I am wanting my calculation to ignore the second slicer. I am aware that I can edit the interactions of the given slicer to have it not impact a specific visual, but I am planning on referencing this measure within other measures, so I can't have this other slicer impacting the value that it calculates. My current measure is 

Test Away Defense = IF(SELECTEDVALUE(Schedule[Away Team])=BLANK(),0,Calculate([Defensive Elo - Away Table],'Away Team Table'[Team] = SELECTEDVALUE('Schedule'[Away Team]),REMOVEFILTERS('Schedule'[Home Team]))). I thought the REMOVEFILTERS function would prevent that slicer from impacting my calculation, but it doesn't seem to be working that way. I appreciate the suggestions in advance!

 

1 ACCEPTED SOLUTION
danextian
Super User
Super User

Hi @spenceratchison ,

 

You will need to use a separate table that doesn't have a relationship (disconnected table) from your fact tables and then create a measure so  it is filtered according to what is selected in the column from that disconnected table.

 

Disconnected Table =
//as a calcualted table
DISTINCT ( 'Table'[Slicer Column] )

 

My Measure =
CALCULATE (
    [My measure],
    FILTER (
        'Table',
        'Table'[Slicer Column] = SELECTEDVALUE ( 'Disconnected Table'[Slicer Column] )
    )
)

OR

My Measure =
CALCULATE (
    [My measure],
    FILTER (
        'Table',
        'Table'[Slicer Column] IN VALUES ( 'Disconnected Table'[Slicer Column] )
    )
)

 

Alternatively,

 

You can still create a relationship between your fact table and that calculated table but keep it INACTIVE. Use USERELATIONSHIP to invoke the relationship between the two

My Measure =
CALCULATE (
    [My measure],
    USERELATIONSHIP ( 'Disconnected Table'[Slicer Column], 'Table'[Slicer Column] )
)

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

3 REPLIES 3
marcopaz
Frequent Visitor

This solution helped me a lot with my problem as well. Thank you so much

danextian
Super User
Super User

Hi @spenceratchison ,

 

You will need to use a separate table that doesn't have a relationship (disconnected table) from your fact tables and then create a measure so  it is filtered according to what is selected in the column from that disconnected table.

 

Disconnected Table =
//as a calcualted table
DISTINCT ( 'Table'[Slicer Column] )

 

My Measure =
CALCULATE (
    [My measure],
    FILTER (
        'Table',
        'Table'[Slicer Column] = SELECTEDVALUE ( 'Disconnected Table'[Slicer Column] )
    )
)

OR

My Measure =
CALCULATE (
    [My measure],
    FILTER (
        'Table',
        'Table'[Slicer Column] IN VALUES ( 'Disconnected Table'[Slicer Column] )
    )
)

 

Alternatively,

 

You can still create a relationship between your fact table and that calculated table but keep it INACTIVE. Use USERELATIONSHIP to invoke the relationship between the two

My Measure =
CALCULATE (
    [My measure],
    USERELATIONSHIP ( 'Disconnected Table'[Slicer Column], 'Table'[Slicer Column] )
)

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Hi @danextian Could you help with this scenario

I need to use finish date and reported date from the same table. create a measure to calculate total orders so that it is not affected by finish date slicer but is affected by reported date. just the reverse for another measure to calculate completed orders(order status =COMP or CLOSE) . should change with finish date slicer  but not with reported date slicer. both these measures have to be used in a column chart to show total orders and completed orders

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.