The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi guys, need help on this.
I want to get the breakdown of leave percentage for mulltiple departments. However, the denominator changes after expanding to leave categories. The denominator should be static which is the total hours of the department per day.
Below is expected result:
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |