topic Re: FILTERED DISTINTCOUNT in DAX Commands and Tips

FILTERED DISTINTCOUNT

PieroPinzone95 — Fri, 07 Apr 2023 13:38:12 GMT

Hi guys, i want to calculate a distintcount as shown in the picture but it give me an error because i'm comparing a "text" value with an "integer" one ... i don't understand well... the filter i'm using is a integer... what i should do?

Re: FILTERED DISTINTCOUNT

Alex_Sawdo — Fri, 07 Apr 2023 14:34:14 GMT

Is the column data type you're trying to filter on a text column or a number column? This would affect the filtering heavily.
I'd recommend that instead of adding in your filter statement as a regular statement wrap it in it's own FILTER function.
Since you have your 2 and 3 values within double-quotes, DAX will treat these as strings and not integers. This is probably why it isn't working, try removing the quotes.

Re: FILTERED DISTINTCOUNT

FreemanZ — Fri, 07 Apr 2023 15:18:30 GMT

hi PieroPinzone95

try like:

Flotte Kinto =
CALCULATE(
DISTINCTCOUNT(VW_Polizze[IdPolizza]),
VW_polizze[IdProdotto] in {2, 3}
)