Week Values From Date Table Show Up Multiple Times

[DataBulbsBiz]

So I have a regular Date Dimension in Power Bi. There is a week column for each date in the date dimension.  However, if I place the week into a column in a table or matrix, each week shows up multiple times. I understand this is because multiple values exist for each week in a dimnesion table because there are seven days in each week. However, this is nonsensical behavior as I want to see averages by week. 

In essence, I want a column that list each week so I can have the measures filter by each week once I put them into that visual table. Why do I need to have each week listed seven times? Quite furstrating!

[Anonymous]

Hi @DataBulbsBiz ，

This is my test data.

Table = ADDCOLUMNS(CALENDAR(DATE(2023,1,1),DATE(2023,12,31)),"value",1,"weeknum",WEEKNUM([Date],2),"weekday",WEEKDAY([Date],2))

Then the result is as follows.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

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

[DataBulbsBiz]

Have you tried your solution to see that it produces the exact same issue as described? If you have not tried, it is not helpful to offer it to others as a solution.

[PowerBigginer]

 Can you provide more details with examples for further assistenace 

[DataBulbsBiz]

Can you please explain what more details you need? There is no measure, no calculated columns or relationship invovled. I did rephrase the OP to make it clearer.
The OP contains all the examples simple question need and details, but I'll try reiterating again: 

There is a date dimension that is date dimension. Each date item has a week column. Each week has multiple values because there are 7 days in a week. Drag and drop the week column into Power Bi visualization table and matrix and you will have multiple rows for each Week. Why is it doing that?