Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi Guys
I am using this measure to count every rows contained "I", and if there are no "I", I want to count it as 0 instead of blank
Solved! Go to Solution.
Hello njxfoster,
If I've understood your question correctly, try replacing "FILTER ( 'Roster', 'Roster'[Completion_Status] = "I" )" with "FILTER ( 'Roster', 'Roster'[Completion_Status] IN { "I", "IT" } )".
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
Proud to be a Super User! | |
Hi @njxfoster
how does your visual look like? What columns are placed in the visual? How does your data model look like?
Hello njxfoster,
If I've understood your question correctly, try replacing "FILTER ( 'Roster', 'Roster'[Completion_Status] = "I" )" with "FILTER ( 'Roster', 'Roster'[Completion_Status] IN { "I", "IT" } )".
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
Proud to be a Super User! | |