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.

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Number of ways. Most obvious is that you have a visual level filter on your column chart visual. Another way might be that the x-axis is coming from some other table and there are non-matching rows.

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous 

    you have exactly 12 Orders which connected with 2 different Situacaos (not sure how to write it correct 🙂 ) 

    Of course, these orders are counted twice in chart - one for each Situacao

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        v-frfei-msft
        Icon for Community Support rankCommunity Support
        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.