Countrows returns only totals over period.

[Yvalson]

Hi there,

I'm trying to show the amount of claims in a given year based on the category of the claim.

I have the following DAX formula:

Count claim categorie = CALCULATE(COUNTROWS('Claim redenen'); 'Claim redenen'[Claim categorie] = "Productkwaliteit")

I have a matrix table that has a list of articles of which I need to know many claims of a particular category have been made.

Currently the entire table just shows the same value "80".

I thought using Calculate would fix this problem, but I can't put my finger on it.

Can anyone help me out here?

Thanks in advance!

Kind regards.

[mussaenda · Accepted solution]

Hi @Yvalson ,

You need a relationship with your Calendar table to reflect the values monthly

[Yvalson]

Thank you I was referencing the wrong table. 'Claims redenen' only has a relation with the Claims table.

The claims table has a relation with the calender table.

Bij counting the rows in Claims it works as intended. I now just need to make sure that the amount is correct.