Forum Discussion

SUMESHKUMAR22's avatar
SUMESHKUMAR22
Icon for Helper IV rankHelper IV
1 year ago
Solved

Measure not filtering as per time Calculation

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 co...
"DAX Commands and Tips"
"Tips and Tricks"
Commands and Tips
  • Hakuna_matata's avatar
    Hakuna_matata
    1 year ago

    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's avatar
SUMESHKUMAR22
Icon for Helper IV rankHelper IV
1 year ago

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's avatar
Hakuna_matata
Icon for Resolver I rankResolver I
1 year ago

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's avatar
    SUMESHKUMAR22
    Icon for Helper IV rankHelper IV
    1 year ago

    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.