Forum Discussion

ohnothimagain's avatar
ohnothimagain
Icon for Helper I rankHelper I
2 years ago
Solved

DAX- Addcolumn and Count with simple condition

Hello everyone, I'm completly stuck in this problem,wish anyone can give me a solution...(maybe easy) I have a table below,and want to count [PN]numbers only adapted distinct [PO] counts over 2. t...
  • OwenAuger's avatar
    OwenAuger
    2 years ago

    ohnothimagain 

    Thanks for testing this, and sorry for my typo! 😅

    You're exactly right, the measure should be

    test91 :=
VAR PN_PO =
    SUMMARIZE ( 'TEST_', 'TEST_'[PN], 'TEST_'[PO] )
VAR PN_PO_Count =
    GROUPBY ( PN_PO, 'TEST_'[PN], "@PO_Count", SUMX ( CURRENTGROUP (), 1 ) )
VAR PN_Filtered =
    FILTER ( PN_PO_COUNT, [@PO_Count] > 2 )
VAR Result =
    COUNTROWS ( PN_Filtered )
RETURN
    Result

    Does that work as intended?

OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
2 years ago

ohnothimagain 

Thanks for testing this, and sorry for my typo! 😅

You're exactly right, the measure should be

test91 :=
VAR PN_PO =
    SUMMARIZE ( 'TEST_', 'TEST_'[PN], 'TEST_'[PO] )
VAR PN_PO_Count =
    GROUPBY ( PN_PO, 'TEST_'[PN], "@PO_Count", SUMX ( CURRENTGROUP (), 1 ) )
VAR PN_Filtered =
    FILTER ( PN_PO_COUNT, [@PO_Count] > 2 )
VAR Result =
    COUNTROWS ( PN_Filtered )
RETURN
    Result

Does that work as intended?

  • ohnothimagain's avatar
    ohnothimagain
    Icon for Helper I rankHelper I
    2 years ago

    Yes! it worked that I wanted it to be.thank you so much! It was really hard for me to solve by myself!