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.
Hi,
I have a dashboard which a table Countries which depends on two measures as slicers: Continent and Currency. The first one is selected with a slicer and the second one, on a table Currency. I want the registries on the Countries table only when a continent is selected on the slicer and a currency on the table. To do so, I have created two measures:
continent= if(calculate(distinctcount('continent'[continent_name]),allselected('continent'[continent_name]))=1,"Y","N")
currency= if(calculate(distinctcount('currency'[currency_name]),allselected('currency'[currency_name]))=1,"Y","N")
In both cases, when a continent and currency is selected, I want the countries table to be shown. But, as you can see in the screenshot, Country is returning values (BA and GE) even if currency's value is 'N'. Why is this happening? I'm struggling with this since yesterday and I'm not able to find a solution 😞 Am I using visual-level filters wrong?
Thanks for your attention and help .
Solved! Go to Solution.
Hi @Anonymous ,
Based on your description, I have created this sample table:
Create this visual control measure, put it in the visual filter of currency table and country table, set its value as 1:
visual control =
IF (
NOT ISFILTERED ( 'Table'[Contient] ),
0,
IF ( NOT ISFILTERED ( 'Table'[Currency] ), 0, 1 )
)
When select a contient in a slicer:
Then select a currency in the currency table:
Attached my sample file in the below, hopes to help you.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , Not very clear but try >= and check
continent= if(calculate(distinctcount('continent'[continent_name]),allselected('continent'[continent_name]))>=1,"Y","N")
currency= if(calculate(distinctcount('currency'[currency_name]),allselected('currency'[currency_name]))>=1,"Y","N")
Hi @amitchandak , sorry, but this didn't solve my issue 😞 When I choose a continent, both currency and countries table are inmediately populated, and this is not the behaviour I'd like to have. I'll try to explain clearer with an example of use:
1. The user should select a continent. Before selecting this continent, tables Currency and Country must appear empty (with no registries)
2. When the user selects a continent, the possible currencies appear, but the Country table must remain empty
3. Only when a currency is chosen in the table, the Countries will appear.
This is the logic I'd like to use, but apart from this, I don't understand why I'm applying a filter but this filter doesn't seem to work. Have visual level filters a logic or hierarchy I'm ignoring?
Hi @Anonymous ,
Based on your description, I have created this sample table:
Create this visual control measure, put it in the visual filter of currency table and country table, set its value as 1:
visual control =
IF (
NOT ISFILTERED ( 'Table'[Contient] ),
0,
IF ( NOT ISFILTERED ( 'Table'[Currency] ), 0, 1 )
)
When select a contient in a slicer:
Then select a currency in the currency table:
Attached my sample file in the below, hopes to help you.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 | |
60 | |
58 |