Dax measure not considering the filter context and not aggregating

[sivarajan21]

Hi,

I have the below visual and highlighted Dax is having problem:

Below is Dax is giving wrong values now.:

noofdays = COUNTROWS(Calendar_)

For the below selected filters,

noofdays dax should display 60 for month of September 2024 and 62 for month of October 2024. The total aggregate value should be 122 days.

My expected output should be like below:

FYI, when I bring in DBName-Points_Id into the visual,it is giving correct values row by row but when removed it doesn't: FYR,

PFA file here Portfolio Performance - v2.15 (1).pbix

Thanks in advance!

@marcorusso @amitchandak @Greg_Deckler @Jihwan_Kim @Ahmedx @PhilipTreacy 

[Anonymous · Accepted solution]

Hi @sivarajan21 

This is because of the direction of the relationship.

The Points[DBName-Point_Id] can not affect the result of the COUNTROW(Calnedar_)(the field [DBName-Point_Id] can not filter the table Calendar_), so the output of the noofdays will always be 30 for September and 31 for October.

Please consider restructuring your model structure to ensure that Points[DBName-Point_Id] is able to filter the table Calnedar_.

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sivarajan21]

Hi @Anonymous ,

Many thanks for the solution!

This article is also useful!

I will accept this as a solution and close this query

Thanks!