When creating a relationship between two table values not showing in matrix visual

[saud968]

Hello, 

I really need urgent help on this one. As I am creating a relationship between multiple tables from Calendar Table which I created. I am not getting values in Matrix. Please review the below screenshot and details.

I am attaching the PBIX file and data file, please review and help

https://drive.google.com/drive/folders/1d-IYQB2oYOAF8zIpbXuabOAkwumsMO9J?usp=sharing 

The below screenshot shows without any relationship between the date table and other tables which I have it gives the count however, it is giving the total count for the year and not by week i.e. Week 28 should 13 Count of CSat and Count of Column 8 should have 11

  

Now with the relationship, the other tables the values goes blank as shown below, even the weeks are not showing. 

 

@amitchandak @AllisonKennedy @Greg_Deckler @ChrisMendoza @Jihwan_Kim  Please help out

[Jihwan_Kim · Accepted solution]

Hi,

I am not 100% sure what you are trying to achieve, but please check the below comment and please try to fix your data model.

- In the fact table, I saw there are two columns describe date & time -> In the Power Query, change the data type to DATE type, not Date/Time type. If you need Time level analysis, create separate columns for time.

- Make sure that your calendar table is assigned as Date Table

-Relationship has to be properly created. I saw that Date column and CSAT column are connected. I think this is incorect.

Thanks.

[saud968]

@Jihwan_Kim Changing data type worked however it is showing incorrect I will work on it if I have any difficulty I will reach out ...Thank your Help 

And Everyone else who assisted on this one.

[saud968]

@Jihwan_Kim I am trying to achieve similar to below screenshot, this is done in excel

[Jihwan_Kim]

Hi,

I could not find all the dimensions that are described in the screenshot.

Please share the complete sample pbix file, then I can try.

Thanks.

[amitchandak]

@saud968 , I doubt some matching data is missing or there is a filter on the page.

check data for two tables at a time. with help from this option check the missing values

[saud968]

@amitchandak I have the slicer to select the quarter. Below are the screenshots of my tables I need to get count of column 8 and Column CSAT 

Total Relation Ship between tables

Once I tried the above option you gave it now show week numbers however no data

[saud968]

I have also tried now to create a similar calendar week table in the other table, still the count is not showing up

 

[Greg_Deckler]

@saud968 Try making the cross filter direction Both for your relationships and see what happens.

[saud968]

@Greg_Deckler I tried still blank....though if I am selecting a blank option on slicer then I am getting the count. It might little incorrect but I can work through it, however, when I am selecting q3 for 2021 it goes blank