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.
I need help, I have this report in which what is inside the red box is made with calculated columns and what is inside the green box with measurements. The problem I have is that the calculated columns can not be applied filters like the one you have of the date and are made with a fixed number of hours (which in this case is the problem) instead with the measures yes. So the same thing I did with calculated columns I did with measures but the individual values are not reflected and only the sum of the total is seen, I need to make the measurements can be seen in the same way as with the calculated columns.
for the calculated columns what I did was create a fixed column called "TOTAL SUPPORT HOURS" with the total hours that is 36 and the formula that I must apply is (time CIBERIT / TOTAL HOURS SUPPORT) * WEIGHTING that weighting are fixed values that you have in another column, the problem is that those hours vary depending on the date can be more hours or less hours, But as I put it in a column that is fixed and the filter is not applied, and with the measurements the date filter is applied but it does not show me the individual percentage values of each box (what is inside the pink box). The individual percentages are not reflected in the same way and with the measurements I only get the correct total but I need those individual values.
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |