Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
in my monthwise ipad usage trend report currently not showing the blank values. i want to dispaly the blanks as zero. So i created the below measure , applied the page level filter order date after 2019 and mm/yy column coming from our date master table. but it's giving unexpected result from 2017. it should display only from 2019/01
Solved! Go to Solution.
@rveerasamy , Try like
Assumed slicer on date of date tbale
measure =
var _mes =CALCULATE(DISTINCTCOUNT(Sales[Order Id]),Sales[IPAD_ORDER]="IPAD")+0
var _min = minx(allselected(Date), Date[Date])
var _max = maxx(allselected(Date), Date[Date])
return
if(max(Date[Date]) >=_min && max(Date[Date]) <=_max, _mes, blank())
@rveerasamy , Try like
Assumed slicer on date of date tbale
measure =
var _mes =CALCULATE(DISTINCTCOUNT(Sales[Order Id]),Sales[IPAD_ORDER]="IPAD")+0
var _min = minx(allselected(Date), Date[Date])
var _max = maxx(allselected(Date), Date[Date])
return
if(max(Date[Date]) >=_min && max(Date[Date]) <=_max, _mes, blank())
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |