Forum Discussion

dw700d's avatar
dw700d
Icon for Post Patron rankPost Patron
3 years ago
Solved

distinct count aggregate

Good day all,   I am trying to create a measure that calculates the distinct count of Circuits with a profit greater than 0.   I am using the measure below. The measure appears to be evaluating on ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    dw700d Try:

    Count of Profit Circuit version 2 =
COUNTROWS(
    FILTER(
        SUMMARIZE(
            'Inventory',
            [Circuit #],
            "_Profit", SUM(Inventory[Profit])
        ),
        [_Profit] > 0
    )
)
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

dw700d Try:

Measure =
  COUNTROWS(
    FILTER(
      SUMMARIZE(
        'Table',
        [Circuit],
        "__Profit", SUM('Table'[Profit])
      )
      [__Profit] > 0
    )
  )
  • dw700d's avatar
    dw700d
    Icon for Post Patron rankPost Patron
    3 years ago

    Greg_Deckler   thank you for your help. I am not quite sure what I am doing wrong. Any thoughts

     



     
    Count of Profit Circuit version 2 =
    COUNTROWS(
        FILTER(
            SUMMARIZE(
                'Inventory',
                [Circuit #],
                "_Profit", SUM(Inventory[Profit])
            )[_Profit], SUM(Inventory[Profit])
        )
        [_Profit] > 0
    )
    )
    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      3 years ago

      dw700d Try:

      Count of Profit Circuit version 2 =
COUNTROWS(
    FILTER(
        SUMMARIZE(
            'Inventory',
            [Circuit #],
            "_Profit", SUM(Inventory[Profit])
        ),
        [_Profit] > 0
    )
)