Forum Discussion

jyaul786's avatar
jyaul786
Icon for Helper II rankHelper II
3 years ago

Dax to remove blank cell

Dear Friends,  i have calendar table: Calendar(Date) and i would like to get always minimum date when select by slicer. so that i wrote measure: Min_Date=CALCULATE(MIN('Calendar'[Date]),ALL('Calend...
Need Help
jyaul786's avatar
jyaul786
Icon for Helper II rankHelper II
3 years ago

Hi, Ahmedx mlsx4 

Both measure dont give correct value.

whenever i slice(filter) the slicer its working fine. when there is no any slicing(no filter on slicer) its give the blank cell

 

image:

 

Thanks for your help

 

mlsx4's avatar
mlsx4
Icon for Memorable Member rankMemorable Member
3 years ago

And, what if you filter in the filter pane where Date <> blank?