Forum Discussion
DAX FILTERING
Hi, I need help. I have two tables connected in via Power BI relationship. The first table acts as the main one and then the second table contains the survey details for each items. I am trying to co...
v-kongfan-msft The table is connected using a helper table with unique values inside the data modelling tab:
Main Table/Table 1:
| Month Name | End of Week | Reporting Date | Product Family |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Windows Consumer |
| December | 12/6/2023 | 12/1/2023 | Unspecified |
| December | 12/6/2023 | 12/1/2023 | Unspecified |
| December | 12/6/2023 | 12/1/2023 | Unspecified |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Windows Consumer |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Windows Consumer |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Windows Consumer |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Unspecified |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Microsoft 365 and Office |
| December | 12/6/2023 | 12/1/2023 | Windows Consumer |
Table 2/Survey Table:
| Month Name | End of Week | Reporting Date | Product Family | Survey Scores |
| December | 12/9/2023 | 12/1/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/1/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/4/2023 | Microsoft 365 and Office | 1 |
| December | 12/9/2023 | 12/4/2023 | Microsoft 365 and Office | 1 |
| December | 12/9/2023 | 12/4/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/4/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/4/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/4/2023 | Windows Consumer | 5 |
| December | 12/9/2023 | 12/4/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/4/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/5/2023 | Microsoft 365 and Office | 1 |
| December | 12/9/2023 | 12/5/2023 | Microsoft 365 and Office | 1 |
| December | 12/9/2023 | 12/6/2023 | Windows Consumer | 1 |
| December | 12/9/2023 | 12/6/2023 | Microsoft 365 and Office | 4 |
| December | 12/9/2023 | 12/7/2023 | Unspecified | 1 |
| December | 12/9/2023 | 12/7/2023 | Microsoft 365 and Office | 4 |
| December | 12/9/2023 | 12/7/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/7/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/7/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/7/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/7/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/7/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/8/2023 | Unspecified | 1 |
| December | 12/9/2023 | 12/8/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/8/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/8/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/8/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/8/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/8/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/8/2023 | Windows Consumer | 5 |
| December | 12/9/2023 | 12/8/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/8/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/8/2023 | Unspecified | 5 |
| December | 12/9/2023 | 12/9/2023 | Unspecified | 1 |
| December | 12/9/2023 | 12/9/2023 | Windows Consumer | 5 |
| December | 12/9/2023 | 12/9/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/9/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/9/2023 | Microsoft 365 and Office | 5 |
| December | 12/9/2023 | 12/9/2023 | Windows Consumer | 5 |
Connectors:
| Month Name |
December |
| End of Week |
| 12/9/2023 |
| 12/16/2023 |
| 12/23/2023 |
| 12/30/2023 |
| Reporting Date |
| 12/1/2023 |
| 12/2/2023 |
| 12/3/2023 |
| 12/4/2023 |
| 12/5/2023 |
| 12/6/2023 |
| 12/7/2023 |
| 12/8/2023 |
| 12/9/2023 |
| 12/10/2023 |
| Product Family |
| Microsoft 365 and Office |
| Windows Consumer |
| Unspecified |