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

     

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

IAA , Try like

Measure =
var _1 =ALLSELECTED('Slicer Table'[Category])
return
sumx( all('Slicer Table'[Category]) , if('Value by date 2'[Category] in _1 ,
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))))

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

Thank you amitchandak ,

Unfortunately, the if-statement does not work in this Dax formula. Any idea how to fix this?