Forum Discussion
Paramjit
Helper II
Helper IIMeasure in Slicer
Hi Team, I have the below measure and need to use in the Slicer but unable to do. Could you pleaes help. Range = CALCULATE(if([Rank 2]/MAXX(ALLSELECTED('Table'),[Rank 2])*100>67,"Long Job...
Paramjit, Try the below approach and let me know if it meets your requirement,
- Keep [Rank 2] Measure
- Create a table
- Check the below logic and create a measure
Range = VAR __Max = MAXX( ALL(<TableName>[ColumnName]),[Rank 2]) VAR __SelValue = SELECTEDVALUE('Table'[Name]) VAR __Perc = DIVIDE([Rank 2],__Max) RETURN SWITCH( TRUE(), __SelValue = "Long" && __Perc > .67,"Y", __SelValue = "Medium" && __Perc > .33, "Y", __SelValue="Short", "Y" )- Add Range to Visual Level Filter and apply Range is 'Y'
- Add Name(from step 2) to slicer
- Test it
Hope it will help you!
Best Regards, Siva Mani Proud to be a Super User! If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SivaMani
Resident Rockstar
Resident RockstarParamjit, Try the below approach and let me know if it meets your requirement,
- Keep [Rank 2] Measure
- Create a table
- Check the below logic and create a measure
Range =
VAR __Max = MAXX( ALL(<TableName>[ColumnName]),[Rank 2])
VAR __SelValue = SELECTEDVALUE('Table'[Name])
VAR __Perc = DIVIDE([Rank 2],__Max)
RETURN
SWITCH(
TRUE(),
__SelValue = "Long" && __Perc > .67,"Y",
__SelValue = "Medium" && __Perc > .33, "Y",
__SelValue="Short", "Y"
)
- Add Range to Visual Level Filter and apply Range is 'Y'
- Add Name(from step 2) to slicer
- Test it
Hope it will help you!
Best Regards,
Siva Mani
Proud to be a Super User!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
