Forum Discussion
Comparison works weird
The model contains of two tables/entities (note the terms are terms from the model, not from power BI itself): - indicator - data source "indicator" is linked to "data source" as one-to-many: mu...
After replacing a typo in the last row __readySourcesCount = __allSourcesCount and using actual table/column names, the result is again incorrect.
Also the issue is not related to decimal vs. whole number comparison as it evaluates to false (for calculated column) even for rows where e.g. total sources = 1, format ready sources = 1 and there is a 1/1 division before comparing to 1
See the screenshot
First, the formula is not a measure. It's a calculated column formula. Second, I don't know your model's structure and data. Probably you have to make sure that you count distinct 'something' in source.
It looks like you're trying to use it in a visual as a measure... I'm confused.
Best
D
It looks like you're trying to use it in a visual as a measure... I'm confused.
Best
D