Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am trying to display the total distinct employees working per day per year, but my All Except formula displays the Total days instead of separating out the days each year...
The formula below is the sum of the distinct count of employees per day:
Solved! Go to Solution.
If this is true, that you are looking for count of distinct combinations such as
count( DISTINCT Date_Day, Employee_Name) from CMPL table
In my view, I will achive using Summarize and CountRows
Emp And Date unique values = COUNTROWS (
Summarize ( 'CMPL Table', 'CMPL Table'[Date Day], 'CMPL Table'[Employee Name])
)
If this is true, that you are looking for count of distinct combinations such as
count( DISTINCT Date_Day, Employee_Name) from CMPL table
In my view, I will achive using Summarize and CountRows
Emp And Date unique values = COUNTROWS (
Summarize ( 'CMPL Table', 'CMPL Table'[Date Day], 'CMPL Table'[Employee Name])
)
So first I created a formula using the advice you sent me...:
This worked! i just had to create another formula thank you!
Glad it worked. Please share the formula to the group...
@sevenhills Thank you!
This result does not give me the subtotal for each year for each row though... these are the formulas i used below:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |