Latest Enterprise DNA Initiatives

DAX for calculating a filtered value per month

I feel really stupid for asking this question.

However, can anybody help me with the DAX for calculating the number of ‘accepted’ and ‘rejected’ incidents per month? I want to be able to create a gauge with a target value etc.

I have attached a screenshot of my table.

Thanks

imageDAX.docx (194.8 KB)

@chrisgreenslade No question is ever silly if you learn something from it. Having said that, you can try something like this:

    Accepted =
    CALCULATE (
    COUNT([The Column with Accepted/Rejected]),
    [The Column with Accepted/Rejected] = "Accepted")

  Rejected =
        CALCULATE (
        COUNT([The Column with Accepted/Rejected]),
        [The Column with Accepted/Rejected] = "Rejected")

When you bring these measures in a visual with Month, you will get the Accepted/Rejected incidents per month automatically if the Incident Type table has a relationship with the Date Table.

I hope it helps.

Thanks.
Mudassir

1 Like

Thank you so much!

Thanks :grinning: