Forum Discussion
Strange Legend Error
The strangest thing is that I have recreated the visual in a new report (copying and pasting all the query steps to make sure it is essentially the same data) and the visual works perfectly there! So it's definitely not the data but almost like something is broken in that specific Power BI report file itself.
mwimberger And I'm not even using measures in this visual:
But the strangest thing is that when I actually write a measure to calculate the number of 'Medium' ones for example then I get the correct 35.
Ahh right. Anonymous
Have you checked that the difference between COUNT and COUNTA ? I think that is where the problem lies. Count ( in the visual with no measures ) will just count numbers, dates and strings and Counta in your measure will count numeric values as well as non blank values, including text, dates and logical values.
Let me know if that helps
Cheers
Manfred
hey mwimberger
so not sure if I was clear enough on this but my measure is working perfectly. There is nothing wrong with the measure, it's when I DON'T use measures is when I start getting this issue. I'm just unsure why because it worked perfectly before but then started acting up after the latest refresh as mentioned in the OG post.
I don't actually want to use measures for this visual.
any ideas on how to make it work again?
mwimberger Just to give you an idea what my data looks like it's something like this:
Index Overall Impact Summary 1 Low 2 Medium 3 Low 4 High 5 High
