Forum Discussion

mamabox22's avatar
mamabox22
Frequent Visitor
4 years ago

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.

 

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

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    mamabox22 , A new measure like

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

  • mamabox22's avatar
    mamabox22
    Frequent Visitor
    4 years ago

    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.




  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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.

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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