Forum Discussion
[Human Logic Failure] Calcualted Column Excludes Second Round of Blanks in OR Statement
Update: This issue was caused by my mind thinking in arrays and expecting a dynamic array style result when I was asking Power BI for a calculated column. I will leave this post here in case anyone e...
Amoda You need to change this:
PercentMeasure = Sum(Table[Was_Labled])/CALCULATE(COUNT(Table[Topic]), ALL(Table))
This does not resolve the issue. The issue persisits.
However, now with morning and caffiene, I see the error of my ways. I am asking for the impossible. A calculated column holds a single truth. Dog or Cat. It cannot assign both Dog and Cat in cases where there is a blank as it is not a demisional array. I was thinking with array logic, not expicit calculated column logic. I was wanting it to return a result depenent on a calculation at the time of the slicer check, not the other way around.
Thank you for taking the time in any case. - I will need to rethink my approach.