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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
mamabox22
Frequent Visitor

Measure on one specified slicer

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.

mamabox22_1-1646675539339.png

 

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?

Measure_Selected_Slicer_PL1 = SELECTEDVALUE('ORG1 LABEL'[NAME], 0)


Does anyone know how i can achieve such goal ?




4 REPLIES 4
v-kkf-msft
Community Support
Community Support

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

v-kkf-msft
Community Support
Community Support

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. 

 

vkkfmsft_0-1647250821661.png

Measure = CALCULATE ( COUNTROWS ( 'Table' ), REMOVEFILTERS ( 'Table'[Column2] ) )

vkkfmsft_1-1647250998405.png

 

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.

mamabox22
Frequent Visitor

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.

mamabox22_0-1646725726836.png

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.




amitchandak
Super User
Super User

@mamabox22 , A new measure like

concatenateX(distinct(union(allselected('ORG1 LABEL'[NAME]) , allselected('ORG1 LABEL 2'[NAME]) )), [Name], " ,")

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors