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.
I added this code to the measure.
Date Range 1=
var xy = CALCULATE(COUNTROWS('vw_ListNew')+0, 'vw_ListNew'[StatusDate] in VALUES(DateRange1[Date]))
return if(isblank(xy),0,xy)
it works for Date Range 1 and date Range 2, but when i add phase it still shows blank. Th
@Anonymous
Try this way;
Date Range 1=
CALCULATE(
COUNTROWS('vw_ListNew'),
'vw_ListNew'[StatusDate] in VALUES(DateRange1[Date]) + 0
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
I tried that and it is not working
@Anonymous
If you could share your PBIX file or a sample of it by saving it to a file sharing option like one drive or google drive, I can check it for you.
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
There is no data when you filter by Phase 1 except for Interventional Type Interventional TX. That's why you see blanks.
You can also use only one CALCULATE and adjust both the time ranges measures like:
TimeFrameDateRange1 =
CALCULATE(
COUNTROWS('vw_patientListNew'),
'vw_patientListNew'[StatusDate] in VALUES(DateRange1[Date])
)
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
How do i show not blank when data is missing?
@Anonymous
@Anonymous
As per my understanding, since there is no data for that combination, DAX will not evaluate anything on that cell. You can only have blanks.
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Is there a work around?
I was looking at some other posts that they used calendar table to join the main table with all the dates and display the no blank values.
Another port said we can use "Show items with no data" would solve.
I tried using both and non of them work.
@Anonymous
Yes, You can create a table and append. but is that really necessary?
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Yes my users are picky about it they don't want to see blanks. I am trying to work around
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |