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 re...
Need Help
  • mussaenda's avatar
    mussaenda
    3 years ago

    Hi Yvalson ,

     

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

mussaenda's avatar
mussaenda
Community 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.