Issues linking several tables with dates and another value

[DanClarkson]

Hi,

I am trying to create a dashboard like the one below (the region will always be either Region 1 or Region 2 as shown in the table descriptions below the mocked up dashboard). The first issue I had was linking the dates correctly between the three tables. I found a great article on creating a calender table and then relating to all three to then allow me to add a date filter to the dashboard to filter for different date periods. That all worked fine. However I wanted to then add another date filter that would allow me to filter down by company. I tried to create links between the tables to related each to the other by the Customer ID so that I could then have that as a filter. However, when trying to create the relationship between the 3 tables on the Customer ID I get an error around the fact that it will creat multiple paths and therefore won't allow the relationship to become active. Therefore the question is, does anyone know based on the sample data below how I can create a dashboard like the mock one below (I would like the main large figures to be cards rather than a table). I then need to be able to have the option to add two filters to the dashboard, one that filters by date and will cause the dashboard to update. The second filter is based on the customer ID/company name to allow me to quickly be able to filter down to a specific company to see their specific figures.

I'm sure a Power PI guru out there will make short work of this 🙂

Many thanks

[dax · Accepted solution]

Hi  @DanClarkson ,

I am not clear about your requirement, we couldn't use Card to achieve this, becuase that the one card will show only one value, you might need to use multiple cards to achieve this goal which means that you need to write multiple measures. Below is my sample, you could refer to it.

Best Regards,
Zoe Zhi

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