Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Select a percentage from a user

I have a user that wants to select values in a matrix that is over a cetain percentage..i.e   selection : show me all returns over 10%    Prod      Returns A           10% B           20% C   ...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

     

    table Value = SELECTEDVALUE('table'[Percentage], 0.1)
Measure = 
IF(
    MAX(Sheet2[Return])>'table'[table Value],
    1,
    0)

     

     

     

    Best regards,

    Lionel Chen

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

hi v-Lionel

 

Doesnt seem to work the measure i interrpreted was as 

Measure1 = IF(MAX([% Returned] > Parameter[ParameterValue],0.1),Parameter[ParameterValue],1)
which does not link to the matrix
could you be a bit more specific
 
Thanks 
Alane
 
 

 

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ，

I'm sorry that I gave your a wrong formula. Let me recap the process and hope to be able to help you.

My understanding is that you have an original data like this:

The work you should do is:

First, create a 'What IF Parameter' like this:

Second, modify the 'Parameter value' in 'Parameter' table:

 

// Add a parameter: 0.1
Parameter Value = SELECTEDVALUE('Parameter'[Parameter], 0.1)

 

SELECTEDVALUE(): https://docs.microsoft.com/en-us/dax/selectedvalue-function 

 

Third: Create another Mesaure:

 

Measure = 
IF(
    MIN(Sheet2[Return]) > Parameter[Parameter Value],
    1,
    0)

 

Fourth:  Add the Measure into the filter of your Table visual:

Fifth: Add a slicer

Best regards,

Lionel Chen