Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
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.
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
Solved! Go to Solution.
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] )
)
Proud to be a Super User!
This solution helped me a lot with my problem as well. Thank you so much
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] )
)
Proud to be a Super User!
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
78 | |
63 | |
52 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
61 | |
60 |