Forum Discussion
Specific Filter
Hello Community, I'm new to Power BI and I have a question - I wish to filter out null values BUT ONLY for those product_ID s where there is no other string value than null. In other words, if a c...
Hi Anonymous
Where were you thinking of creating this?As a calculated column you could do something like this:
Test value = If(BLANK() in CALCULATETABLE(Values(Sales[PaymentDate])) --Are there blanks in the other list&& CALCULATE(DISTINCTCOUNT(Sales[PaymentDate])) = 1 --And there is only one variant in the data,"Only Nulls", "Mixed")Here for each shopping centre it is joined to a Sales table.Each centre has multiple transactions.If the Centre only has one transaction and its blank then return Only Nulls.I could then use this as a filter on the visual.
Hi Anonymous
Where were you thinking of creating this?
As a calculated column you could do something like this:
Test value = If(
BLANK() in CALCULATETABLE(Values(Sales[PaymentDate])) --Are there blanks in the other list
&& CALCULATE(DISTINCTCOUNT(Sales[PaymentDate])) = 1 --And there is only one variant in the data
,"Only Nulls", "Mixed")
Here for each shopping centre it is joined to a Sales table.
Each centre has multiple transactions.
If the Centre only has one transaction and its blank then return Only Nulls.
I could then use this as a filter on the visual.