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'm working on creating a visual that states how many notices are resolved and how many notices are open. Each of these fields is a card, and use the measure below to pull the number of records with the Open or Resolved statuses:
Resolved Notices = calculate(count(tblNotice[noticeStatus]),tblNotice[noticeStatus]="Resolved")
Open Notices = calculate(count(tblNotice[noticeStatus]),tblNotice[noticeStatus]="Open")
For some reason, resolved notices updates correctly upon refreshing the data, but Open Notices stays at a value of one (which, it's worth noting, was never actually one to begin with as there were seven Open Notices when I originally loaded the table).
Any ideas why this could be acting up?
Solved! Go to Solution.
I think I've solved the issue actually--I had a brainstorm and realized the problem was a slicer I put in that was filtering on the resolution date. Oops!! And to think I spent an hour on this.
I have to guess that what you THINK says "Open" does not actually say "Open". Maybe a space before/after?
Only other thing I can say is that I tend to use COUNTROWS(tblNotice), instead of COUNT( ) -- but I don't *think* that makes any difference.
Thanks for your reply scottsen,
Not sure if this would change anything but I've noticed now that if I set a report level filer, the filter box does seem to acknowledge that there are 8 open notices. However the visual still reads "1". Does that make any difference?
I'm going to try playing with leading/trailing spaces now and see if that might have anything to do with it.
In your table, you could add a calculated column that is just IsOpen = tblNotice[noticeStatus] = "Open" and make sure you are getting a "TRUE" where you expect?
It's returning "true" for all values I expected 😕
I think I've solved the issue actually--I had a brainstorm and realized the problem was a slicer I put in that was filtering on the resolution date. Oops!! And to think I spent an hour on this.
Bam! Congrats 🙂
woah.
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 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |