Forum Discussion

jacob2102's avatar
jacob2102
Icon for Helper II rankHelper II
5 years ago
Solved

CountX or other DAX expression

Hi,   I have a data table with different publications and the participating groups in each publication. Publication Group P1 a P1 b P1 c P2 a P2 c P3 b P4 a P4 ...
  • wdx223_Daniel's avatar
    wdx223_Daniel
    5 years ago

    jacob2102 

    this code could be work

    PublicationCount:=COUNTROWS(FILTER(ALL(Table1[Publication]),CALCULATE(DISTINCTCOUNT(Table1[Group]),ALLEXCEPT(Table1,Table1[Publication]))>2))
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

jacob2102 

this code could be work

PublicationCount:=COUNTROWS(FILTER(ALL(Table1[Publication]),CALCULATE(DISTINCTCOUNT(Table1[Group]),ALLEXCEPT(Table1,Table1[Publication]))>2))