I need count values in another no related table

[gpaula]

I have 4 tables. First one with region, day and a grade, second one with the region details and a third one with month and a collumn with the information about the grade necessity (yes or no) for witch month in the year and the last one is the calendar table. 

I want a tale with the regions, information about necessity of grade (table3) and the count of grades (table1), it is possible do that with mesuares? It s important that i can use date filter in the dashboard, like the picture below.

PS: i cant conect table 1 and 3 because the many to many conection.

[Icey · Accepted solution]

Hi @gpaula ,

To my understand, "Month" column in Table 3 represents each month. It should be matched with one column represents each month, too. 

Therefore, please create a Month column in your Calendar table and use this column to create relationship between Calendar table and Table 3 like below.

Month = EOMONTH([Date],-1)+1

Then you can get what you want:

For more details, please check the attached .pbix file.

Best Regards,

Icey

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

[VahidDM]

HI @gpaula 

Can you share a sample of your table data?

Appreciate your Kudos!!

[gpaula]

Hi. Of course.

Table 1

Region	CodRegion	Day	Grade
A	01	18/10/2021	10
B	02	18/10/2021	9
A	01	19/10/2021	9
B	02	20/10/2021	8
C	03	20/10/2021	9

Table 2:

CodRegion	Detail1	Detail2
01	xxx	yyy
02	aaa	bbb
03	ccc	ddd

Table3:

CodRegion	Month	Requested?
01	01/10/2021	yes
01	01/11/2021	no
02	01/10/2021	yes
02	01/11/2021	yes
03	01/10/2021	yes
03	01/11/2021	yes

Is it enough?