Measure not filtering as per time Calculation

[SUMESHKUMAR22]

Hi Community,

In the attached pbix file, Im facing issue with Problem -1 in atached pbix.

Issue : Im trying to use colesce function in the base measure 'vall' but due to that the date filter context is getting removed and showing data for all dates. But when i dont use colesece it works fine. 


Thanks in advance! 

[Hakuna_matata]

Hi @SUMESHKUMAR22 ,
I may suggest updating the "val" to below measure

val =

CALCULATE(

    COALESCE(SUM('Sample'[VALUE]), 0),

    ALLSELECTED('DIM Date'[Date])

)

Hope it help!

If this solved your problem, please accept it as a solution!!

[SUMESHKUMAR22]

Hi @Hakuna_matata ,

It didn't work still even after adjusting the base measure 'vall' .

Any other possibilities to fix this ?

Thanks in advance!

[Hakuna_matata · Accepted solution]

Hi @SUMESHKUMAR22 ,
Try this measure

vall =

CALCULATE(

    SUM('Sample'[VALUE]),

    ALLSELECTED('DIM Date'[Date])

)

If this solved your problem, please accept it as a solution!! ^_^

[SUMESHKUMAR22]

@Hakuna_matata , Well even if we use sum(value) , still it will work 🙂

Im actually trying to show 0 whereever the 'Organic' is coming 0 for specific dates, that the reason I used (colesce,0) .

Thanks for the repsonses.

[SUMESHKUMAR22]

Hi Team, 

Any suggestions please. 😞

Thanks!