Forum Discussion

HarryR's avatar
HarryR
Regular Visitor
3 years ago
Solved

Filter Minimum Y-Axis Based on Slicer

Hi all,    This has been something I've been trying to do for some time, and thought I might be able to solve with Field Parameters, but alas I've hit another roadblock. I'm trying to add a slic...
Need Help
  • vicky_'s avatar
    vicky_
    3 years ago

    Create a numeric field parameter slicer.

    Then try use something similar to the following DAX as the measure:

    No. Items = 
var items = CALCULATE(COUNT([Items]), ALLEXCEPT(Table, [Category])
var minItems = SELECTEDVALUE([Parameter Value])
return IF(items > minItems, items, BLANK())

     

vicky_'s avatar
vicky_
Icon for Super User rankSuper User
3 years ago

Create a numeric field parameter slicer.

Then try use something similar to the following DAX as the measure:

No. Items = 
var items = CALCULATE(COUNT([Items]), ALLEXCEPT(Table, [Category])
var minItems = SELECTEDVALUE([Parameter Value])
return IF(items > minItems, items, BLANK())

 

HarryR's avatar
HarryR
Regular Visitor
3 years ago

Thanks man, this worked!