Filter a table based on a slicer

[Gueray]

Hello Everybody !

I'm new to power BI and so i'm trying to filter a table based on a slicer 

I have a [Date added] for the data and i want to select only rows where the date difference between [date added] and today

Here's the dax query that i came up with so far : 

Filter= IF(VALUE(DATEDIFF('Extraction devis organisation'[Date added].[Date];TODAY();DAY)) >= MIN(Slicer[SLICER Selection]) ; "O";"N")

and on the filter panel i select only rows with "O"

The slicer table has no relationships with other tables and yet it doesn't work

Does anyone have a clue why 

Thany you

[Eric_Zhang]

---

@Gueray wrote:

Hello Everybody !

I'm new to power BI and so i'm trying to filter a table based on a slicer 

I have a [Date added] for the data and i want to select only rows where the date difference between [date added] and today

Here's the dax query that i came up with so far : 

Filter= IF(VALUE(DATEDIFF('Extraction devis organisation'[Date added].[Date];TODAY();DAY)) >= MIN(Slicer[SLICER Selection]) ; "O";"N")

and on the filter panel i select only rows with "O"

The slicer table has no relationships with other tables and yet it doesn't work

Does anyone have a clue why 

Thany you

---

@Gueray

So I guess that the Filter = is an expression for a calculated column, right? Slicer works on visual level, it can't effect calculated column/table which based on source data. In summary, calculate column/table has Pretreatmented before selected on slicer, instead of calculated column, try to apply a filter expression to your measures.

measure =
CALCULATE (
    [yourMeasureHere],
    FILTER (
        'Extraction devis organisation',
        TODAY () - MIN ( 'Extraction devis organisation'[Date added] )
            >= MIN ( Slicer[SLICER Selection] )
    )
)

[Gueray]

@Eric_Zhang

[yourmeasurehere] what do you mean by it because in my example i didn't introduce any measure

Thank you

[Eric_Zhang]

---

@Gueray wrote:

@Eric_Zhang

[yourmeasurehere] what do you mean by it because in my example i didn't introduce any measure

Thank you

---

@Gueray

You could replace the measure like SUM('yourtable'[yourColumn])

[Gueray]

I did what you said but unforunately it didn't work do you have any other method ?

[Eric_Zhang]

---

@Gueray wrote:

I did what you said but unforunately it didn't work do you have any other method ?

---

@Gueray

Would you mind post any sample data and expected output so that I could have a better understanding on your case?