Forum Discussion
DAX dynamic dimension value (calculated column value) based on measure defined by slicer
Hello DAX fellows I am trying to create a dimension (table column) that changes its value based on selected slicer value. The use case is: Select an X value and for each row of table calculat...
You would need to create a measure like
Above Threshold = IF( SELECTEDVALUE('Table'[Value]) > SELECTEDVALUE( 'Threshold Table'[Threshold]),1, 0)You can then use that as a visual filter to show only things where [Above Threshold] = 1. You can also use it in other calculations like
Sum above threshold = SUMX( FILTER( 'Table', [Above Threshold] = 1), 'Table'[Amount])
Thanks, but that's not exactly what I need.
I need to split my population into two categories (dimension values true and false) and be able to compare and filter these 2 categories by different KPIs. That is why I was thinking about the dimension.
I would be able to create measures that use the slicer, but I need to see the underlying data (e.g. which stores have profitability less than the dynamic value from the slicer).