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 two measurements. One measure counts people over the age of 50 who have won a medal, and the other counts people under the age of 50 who have won a medal.
My intention is to fill empty values with zeroes. When I try:
"if (table[column] = blank(), 0, table[column])"
The table is enlarged
Solved! Go to Solution.
Try:
medals > 50 =
VAR _Calc = IF(ISBLANK(MAX(Table[Medal])), BLANK(),[Count medals > 50] + 0)
RETURN
IF(ISINSCOPE (Table[Medal]), _Calc, [Count medals > 50)
Proud to be a Super User!
Paul on Linkedin.
Post deleted as requested
If your request is unrelated to the original question in the thread, please start a new thread (and delete the above post). Thank you!
Proud to be a Super User!
Paul on Linkedin.
Hi,
Share the link from where i can download your PBI file.
Try:
medals > 50 =
VAR _Calc = IF(ISBLANK(MAX(Table[Medal])), BLANK(),[Count medals > 50] + 0)
RETURN
IF(ISINSCOPE (Table[Medal]), _Calc, [Count medals > 50)
Proud to be a Super User!
Paul on Linkedin.
User | Count |
---|---|
85 | |
84 | |
68 | |
66 | |
56 |
User | Count |
---|---|
126 | |
102 | |
90 | |
84 | |
66 |