Forum Discussion

Yvalson's avatar
Yvalson
Frequent Visitor
3 years ago
Solved

Countrows returns only totals over period.

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.

 

Need Help

2 Replies

  • mussaenda's avatar
    mussaenda
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi Yvalson ,

     

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

    • Yvalson's avatar
      Yvalson
      Frequent Visitor
      3 years ago

      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.