Forum Discussion

geroagostini's avatar
geroagostini
Icon for Helper I rankHelper I
3 years ago
Solved

DAX COUNT based on multiple criteria in same table

Hi,    In the same table ("Table Z") i have 2 columns: Column A and Column B.  Column A                   Column B      done                          7261     on work                    13     ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago
    Test = Calculate(COUNT(TestTable[B]), TestTable[A] = "done" || TestTable[A] = "on work")
     
     
    Here you go pal, tested it so it should work 🙂 accept as solution if it works for you! 🙂 
Anonymous's avatar
Anonymous
Not applicable
3 years ago
Test = Calculate(COUNT(TestTable[B]), TestTable[A] = "done" || TestTable[A] = "on work")
 
 
Here you go pal, tested it so it should work 🙂 accept as solution if it works for you! 🙂 
geroagostini's avatar
geroagostini
Icon for Helper I rankHelper I
3 years ago

Thank you my friend!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    No problem pal! Good luck with your report!