Show distinct values of week for each day

[bhargavareddy89]

I have to Create 2 measures
Distinct count for the day
Distinct count for week

I am able to create measure
Distinct count for the day(DD) = CALCULATE(DISTINCTCOUNT('Sheet1'[EE Num]))
Distinct count for week (DW) = CALCULATE(DISTINCTCOUNT(Sheet1[EE Num]),USERELATIONSHIP(Sheet1[Start of week],'date'[Date]))

I am getting data only for Start of week, but I need to show same values for entire week

Please let me know if anyone got solution
Getting output in Power BI

output should be like

Thanks

Bhargav

[Anonymous]

Hi, @bhargavareddy89 

You can share pbix files without sensitive data for testing purposes, which will help you solve the problem faster.

Best Regards,
Yang
Community Support Team