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.
I have created two columns that both will either return a "1" or a "blank". Both columns are Data type: Whole number, Format: General (I've tried changing this to Whole number as well). My Countrows measure is as follows:
Please help me understand this error? Thank you!
Solved! Go to Solution.
Try without double quotes
= COUNTROWS(FILTER(Table1, Table1[HEMORRHAGE COUNT] = 1 || Table1[Complication (full)] = 1))
Lesson learned, thanks so much!
Try without double quotes
= COUNTROWS(FILTER(Table1, Table1[HEMORRHAGE COUNT] = 1 || Table1[Complication (full)] = 1))
User | Count |
---|---|
80 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
97 | |
88 | |
81 | |
61 |