Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I need to show the maximum daily attendance per week, month, ytd on a line chart. In this matrix example, the maximum for employee attendance should be 77 employees when June is selected; but when week of June 12 is selected it should show 71 employees.
Currently, it's showing 80 employees on week of June 12:
And 94 employees when month of June is selected:
I wanted it to be a fixed unique daily count regardless of date selected (weekly,monthly, ytd).
Those numbers likely represent the DISTINCTCOUNT for the given periods.
Please define what you mean by "selected". You will likely need to write a measure that includes SUMMARIZE and MAXX.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...