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 guys,
i am currently facing an issue which surely is easy fixable, but i coudnt find any help online, so i am asking you now.
I am trying to work with values which arent fixed, so i want to make a slicer so that the user can specify which value is "the correct" one.
What i tried so far:
Making 2 slicers which are looking on the same table/same column.
I need now a measure for one of the slicer and another slicer on the other, without intervering another.
And i need to work with the values in other measures and other pages.
So basically i want a settings page where i can set my variables.
Something like this will always consider both slicers. So how can i change it that only Slicer 1 is measured?
Does anyone know how i can achieve such goal ?
Hi @mamabox22 ,
Has your problem been solved? If it is solved, please mark a reply which is helpful to you.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
Hi @mamabox22 ,
I am not sure if I understood your question correctly. If you want to remove filter from the specified slicer, you can try the REMOVEFILTERS function.
This is my test.
Measure = CALCULATE ( COUNTROWS ( 'Table' ), REMOVEFILTERS ( 'Table'[Column2] ) )
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey,
thank you for the reply, but this is not really what i am looking for.
I will summerise what my output will look like and i hope this helps.
You showed me how i can get 1 string but i want to work with all of these values individually.
After i got my Label[Name] selected i want to work with these 2 values in for example in a matrix and want to refere to other attributes in that table with a "smart"filter with the Label[name].
So basically i want to have the selected values insted of the chassis_type.
If i work with your value i woudnt be able to seperate it.
@mamabox22 , A new measure like
concatenateX(distinct(union(allselected('ORG1 LABEL'[NAME]) , allselected('ORG1 LABEL 2'[NAME]) )), [Name], " ,")
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 |
---|---|
18 | |
15 | |
12 | |
11 | |
8 |
User | Count |
---|---|
24 | |
18 | |
12 | |
11 | |
10 |