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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

Huh, I just ran into a similar situation last night and I ended up brute forcing it. I actually had 16 columns that I had to deal with. What I did was create measures for each column and then a calculated column that summed them all up. So, in your case you might have:

 

MetricBasketBallGT3 = IF(SUM([Basketball])>3,1,0)

MetricTennisGT3 = IF(SUM([Tennis])>3,1,0)

MetricHockeyGT3 = IF(SUM([Hockey])>3,1,0)

MetricAllGT3 = [MetricBasketBallGT3] + [MetricTennisGT3] + [MetricHockeyGT3]
CalculatedColumn = [MetricAllGT3]

You might not need the calculated column unless you wanted to know that number for each individual. I needed it because I was computing an overall average between the 16 columns but I wanted to exclude zeros when computing that average.

 

It was late last night, so perhaps I just didn't have my creative thinking cap on with regard to how to solve this more elegantly...