Forum Discussion
Solved
Count as per Area
Hi All, I have below data in Table Visual in PBI desktop, where StatusMeasure is generated dynamically based on ID and few conditions No when I want to count the Distinct IDs for each Area an...
Thanks I resolved it by myself with help of DAX using KEEEPFILTERS
1) A measure can’t be used as a Legend category
In a column/stacked chart, Legend must be a column (categorical field). A DAX measure (your StatusMeasure) can’t create legend buckets by itself. So if you want “Yes/No” as the legend, you need a real column in the model (calculated column / in the source)
2) Your StatusMeasure depends on “Login being in the visual”
That usually happens when the measure uses something like SELECTEDVALUE(Widget[Login]).
When you remove Login from the visual, there are multiple logins in scope, thus, SELECTEDVALUE() becomes blank.So you need to rewrite the logic so it works at the grain you want (Area/ID), not at the grain of the table visual.