Forum Discussion
'OR' include blank values in date slicer
Date should not be joined with receive or uses cross join if have active join
measure = var _min = minx(allselected(Date,Date[Date]) var _max = minx(allselected(Date,Date[Date]) var _maxval = if(isfiltered(Slicer[Allowblank]),max(Slicer[Allowblank]),blank()) return if(_maxval ="Allowblank", calculate(sum(table[Value]),filter(all(Table[Receive Date]),Table[Receive Date]>=_min && Table[Receive Date]>=_max && isblank(Table[Receive Date]))) , calculate(sum(table[Value]),filter(all(date),Date,Date[Date]>=_min && Date[Date]>=_max)) )For use relation and crossfilter refer :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Appreciate your Kudos.
Super UserDate should not be joined with receive or uses cross join if have active join
measure =
var _min = minx(allselected(Date,Date[Date])
var _max = minx(allselected(Date,Date[Date])
var _maxval = if(isfiltered(Slicer[Allowblank]),max(Slicer[Allowblank]),blank())
return
if(_maxval ="Allowblank",
calculate(sum(table[Value]),filter(all(Table[Receive Date]),Table[Receive Date]>=_min && Table[Receive Date]>=_max && isblank(Table[Receive Date])))
,
calculate(sum(table[Value]),filter(all(date),Date,Date[Date]>=_min && Date[Date]>=_max))
)For use relation and crossfilter refer :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Appreciate your Kudos.
Hey amitchandak
Thanks for the reply, I am having trouble understanding the "slicer[allowblank]" part.
Any chance you can attach a demo pbix files?
Thanks
- amitchandak
slicer[allowblank] is for checking, weather blank is allowed on not.
Hi ,
Can you please guide me what the "Slicer[Allowblan] is refering to? I can see you have mentioned it is to see weather blank is allowed on not. but this is a column in our table? or a slicer? not sure how to get this.