Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hey Community -
This should be simple but I am not sure what is going on here. I have a simple measure where I am trying to calculate a count based on two filter criteria. The 'Assignment' measure is just a COUNTROWS then I am filter based on a Grade being BLANK and a Submission Time not being BLANK. However, as you can see in my red box below, for some reason it is coulnting assignments with a grade of 0 as ungraded even though my logic in my measure. I am not sure what is going on here, does anyone know how to fix this?
Thanks in advance for all your help!
Ryan
Solved! Go to Solution.
@ryan_b_fiting , Use like
isblank(Table[Column]) // return true and false
for not
not(isblank(Table[Column])) // return true and false
@ryan_b_fiting , Use like
isblank(Table[Column]) // return true and false
for not
not(isblank(Table[Column])) // return true and false
Hey @amitchandak
I am not sure what you are meaning by this, how would this go into the measure?
Or are you saying to use a calculated column?.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
59 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |