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