Forum Discussion

villa1980's avatar
villa1980
Icon for Resolver II rankResolver II
1 year ago
Solved

If statement and count in DAX

Hi,  I have a table with a lot of Descriptions and for the current month I would like to count these descriptions if another column (status) states "Busy". However, when I use an if statement with a...
Need Help
  • vojtechsima's avatar
    vojtechsima
    1 year ago

    Hello, villa1980 
    the most straightforward thing that comes to my mind is this:

    CALCULATE(
DISTINCTCOUNT('Table'[Description]),
'Table'[Status] = "Busy"
)
villa1980's avatar
villa1980
Icon for Resolver II rankResolver II
1 year ago

I have answered my own question 🙂

By using sumx this has resolved it 🙂