Forum Discussion

magtuto's avatar
magtuto
Helper I
9 years ago
Solved

Dax Help

If I had a table that had the following columns:   | Name |  Basketball |  Tennis | Hockey | | John   |   3              |  3          |  2          | | Chris  |   3              |  3          | ...
Need Help
  • magtuto's avatar
    magtuto
    9 years ago

     

    CheenuSing

     

    Actually I figured it out as soon as i posted it and its similar to what you have posted.  But I ended up using the measure as per below:

     

    All Categories 3 & Above = CALCULATE(
    COUNTROWS(Table),
    Table[Column1]> 2, Table[Column2]> 2, Table[Column3]>)

     

    Thanks to everyone for thier contibution.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

magtuto

 

Try the expression 

 

TotRows = Calculate ( CountRows(YourTable),
                                   Filter( ALL(YourTable),
                                                   (  YourTable[ Hockey ] >=3 &&YourTable[  Basketball ] >= 3 && YourTable[  Tennis ]
                                                   )
                                            )
                                   )

 

If this works please accept this as solution and also give KUDOS.

 

Cheers

 

CheenuSing

  • magtuto's avatar
    magtuto
    Helper I
    9 years ago

     

    CheenuSing

     

    Actually I figured it out as soon as i posted it and its similar to what you have posted.  But I ended up using the measure as per below:

     

    All Categories 3 & Above = CALCULATE(
    COUNTROWS(Table),
    Table[Column1]> 2, Table[Column2]> 2, Table[Column3]>)

     

    Thanks to everyone for thier contibution.