Forum Discussion

IAA's avatar
IAA
Icon for Helper I rankHelper I
6 years ago
Solved

Dax slicer multiple selections

Dear Community, I am building a cashflow forecast, where the due date of bills can dynamically changed with an X number of days, using a parameter. This is combined with a slicer where the specifi...
Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago


    IAA 

    I am not sure why you have a disconnected slicer for the category

    Try this measure:

    Measure = 
IF (
    
    COUNTROWS(
        INTERSECT(    
        ALLSELECTED ( 'Slicer Table'[Category] ),
        FILTERS('Value by date 2'[Category] )
    ))>0,
    CALCULATE (
        SUM ( 'Value by date 2'[Value] ),
        DATEADD ( DimDate[Date], - [Value Parameter], DAY )
    ),
    CALCULATE (
        SUM ( 'Value by date 2'[Value] ),
        DATEADD ( DimDate[Date], 0, DAY )
    )
)

     

    ________________________

    Did I answer your question? Mark this post as a solution, this will help others!.

    Click on the Thumbs-Up icon on the right if you like this reply 🙂

    YouTube, LinkedIn

     

IAA's avatar
IAA
Icon for Helper I rankHelper I
6 years ago

Thank you so so much Fowmy ,

I was struggling for days to fix this and I am very happy that I finally got a way how this works. For learning purposes I will study the exact formula tomorrow, but now glad it works

 

You made my day!

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
6 years ago

IAA 

Glad it worked!

 

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn