topic Re: Measure not filtering as per time Calculation in DAX Commands and Tips

Measure not filtering as per time Calculation

SUMESHKUMAR22 — Fri, 28 Mar 2025 15:56:43 GMT

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!

Re: Measure not filtering as per time Calculation

SUMESHKUMAR22 — Sat, 29 Mar 2025 06:35:57 GMT

Hi Team,

Any suggestions please. 😞

Thanks!

Re: Measure not filtering as per time Calculation

Hakuna_matata — Sat, 29 Mar 2025 09:03:31 GMT

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!!

Re: Measure not filtering as per time Calculation

SUMESHKUMAR22 — Sat, 29 Mar 2025 11:23:20 GMT

Hi Hakuna_matata ,

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

Any other possibilities to fix this ?

Thanks in advance!

Re: Measure not filtering as per time Calculation

Hakuna_matata — Sat, 29 Mar 2025 12:01:13 GMT

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!! ^_^

Re: Measure not filtering as per time Calculation

SUMESHKUMAR22 — Sat, 29 Mar 2025 12:44:41 GMT

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.