Forum Discussion
DISTINCTCOUNT values difference between AXIS visual and card visual
Hello, guys! I need some help over here, if you could so, I appreciate. I'm using a DISTINCTCOUNT to get the distinct values from column A applying this measure to a Card, but when I apply to a ...
Hi Anonymous ,
Here we go.
Measure 2 = VAR s = MAX ( Planilha1[Situação] ) VAR no = CALCULATETABLE ( VALUES ( Planilha1[Ordens] ), FILTER ( ALL ( Planilha1 ), Planilha1[Situação] <> s ) ) RETURN IF ( ISFILTERED ( Planilha1[Situação] ), CALCULATE ( DISTINCTCOUNT ( Planilha1[Ordens] ), FILTER ( Planilha1, NOT ( Planilha1[Ordens] IN no ) ) ), DISTINCTCOUNT ( Planilha1[Ordens] ) )Pbix as attached.
Hi, az38
I found this same answer too.
Actually, I've twelve orders been counted twice by different situations (Haha, Situação = Situation.. sorry about that, I sent to a BR Forum too).
But I was trying to do a distinct one that ignore this "situation" thing and only count all distinct orders independent where it is (where is the context).
I don't even know if this will work fully.. but I wanna give a try before use a new dataset without these double orders.
(The original dataset came from my company and run by invoice and not by orders, so if I've to change it.. it'll take a while. And I don't wanna it).
Anyway, thanks for your help!
v-frfei-msft
Community Support
Community SupportHi Anonymous ,
Here we go.
Measure 2 =
VAR s =
MAX ( Planilha1[Situação] )
VAR no =
CALCULATETABLE (
VALUES ( Planilha1[Ordens] ),
FILTER ( ALL ( Planilha1 ), Planilha1[Situação] <> s )
)
RETURN
IF (
ISFILTERED ( Planilha1[Situação] ),
CALCULATE (
DISTINCTCOUNT ( Planilha1[Ordens] ),
FILTER ( Planilha1, NOT ( Planilha1[Ordens] IN no ) )
),
DISTINCTCOUNT ( Planilha1[Ordens] )
)
Pbix as attached.