Forum Discussion

ktg2019's avatar
ktg2019
Frequent Visitor
1 year ago
Solved

Removing a slicer interaction while still using the slicer value

In my report, a user will select a date using a date between slicer and we're only using the minimum date selected.   This date can be any day of the week. I want to show the sales numbers fo...
date calculations
date ranges
DAX
powerbi
slicer interactions
slicers
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, ktg2019 

    You can try the following method to achieve your need.

     

    Measure:

     

    Sales = 
VAR _quarterSlicer = SELECTEDVALUE(Slicer[Quarter])
VAR _quarterSales = SELECTEDVALUE(Sales[Quarter])
VAR _yearSlicer = SELECTEDVALUE(Slicer[Year])
VAR _yearSales = SELECTEDVALUE(Sales[Year])

VAR _result = CALCULATE(SUM(Sales[Sales]),FILTER(Sales,_yearSales = _yearSlicer && _quarterSales = _quarterSlicer ))
RETURN
IF(_yearSales = _yearSlicer && _quarterSales = _quarterSlicer,1)

     

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know.     Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, ktg2019 

You can try the following method to achieve your need.

 

Measure:

 

Sales = 
VAR _quarterSlicer = SELECTEDVALUE(Slicer[Quarter])
VAR _quarterSales = SELECTEDVALUE(Sales[Quarter])
VAR _yearSlicer = SELECTEDVALUE(Slicer[Year])
VAR _yearSales = SELECTEDVALUE(Sales[Year])

VAR _result = CALCULATE(SUM(Sales[Sales]),FILTER(Sales,_yearSales = _yearSlicer && _quarterSales = _quarterSlicer ))
RETURN
IF(_yearSales = _yearSlicer && _quarterSales = _quarterSlicer,1)

 

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum