Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    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.

     

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Here we go.

Measure = SUMX(VALUES(Planilha1[Situação]),CALCULATE(DISTINCTCOUNT(Planilha1[Ordens])))

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi, v-frfei-msft 

 

Thanks for your help! It's a good way too.

But I was trying to do the contrary.. apply the total of the first card (5,227) to the situation chart (when adding up all the situations, have  5,227 too).

 

How I said to az38 

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).