Shoe distinct values of week for each day

Palagiri Bhargava Reddy 0 Reputation points
2024-06-17T16:28:56.94+00:00

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
User's image

output should be like

User's image

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,645 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. VarunTha 5,740 Reputation points Microsoft Vendor
    2024-06-18T06:12:49.4533333+00:00

    Hi Palagiri Bhargava Reddy,
    Thank you for reaching out to us on the Microsoft Q&A forum.

    This topic is currently not supported in the Q&A forums.

    I recommend initiating a new discussion through the Power BI forums Moderators are readily available there to assist you and provide guidance.

    Please don't forget to Accept helpful answer and close this thread.

    0 comments No comments