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"
)
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi villa1980 ,

 

Based on your description, I created these data.

 

You can create a measure.

BusyCount = CALCULATE(
    COUNT('Table'[Description]),
    FILTER(ALL('Table'),'Table'[Status] = "Busy" &&
    MONTH('Table'[Date]) = MONTH(TODAY()))
)

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.