Forum Discussion

DPIT_FR's avatar
DPIT_FR
Regular Visitor
2 years ago

combine filter doesn't work (with parameters)

Hello all, I tried to filter a table with two filters, but it doesn't work (returns blank lines except for a curious total). My objective is to enable users to filter based on a threshold (with par...
Need Help
DPIT_FR's avatar
DPIT_FR
Regular Visitor
2 years ago

hello freginier , Anonymous 

 

Thanks a lot for your help. Unfortunately, I can't get the result... and I don't understand how I get this result....

Unfortunately, I wasted too much time on this problem, I will  see with my client if it is not possible to remove this functionality...

However, if you see another possibility, I will take note of it. (I put the formulas below). In any case, once again I thank you for the time spent.

 

 

Nb Passage Horaire (Compteurs EXCLUS) =
CALCULATE(sum(Passage[NB_PASSAGE_HORAIRE_ESTIME]),
    FILTER(
        Passage,
        Passage[NB_PASSAGE_HORAIRE_ESTIME] < parameter[Parameter_value]
    )
)
 
TestYearBefore1 =
CALCULATE(
   SUMX(         FILTER(         Passage,         Passage[NB_PASSAGE_HORAIRE_ESTIME] < parameter[Parameter_value] && DATEADD(Calendrier[Date], -1, YEAR)         ),Passage[NB_PASSAGE_HORAIRE_ESTIME]     ) )
 
 
TEstYearBefore2 =
CALCULATE (
    SUMX (
        FILTER ( 'Passage', 'Passage'[NB_PASSAGE_HORAIRE_ESTIME] > parameter[Parameter_value] ),
        [NB_PASSAGE_HORAIRE_ESTIME]
    ),
    DATEADD ( 'Calendrier'[Date], -1, YEAR )
)
 
one more time :thank you much