Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
15 | |
11 | |
7 |
User | Count |
---|---|
25 | |
24 | |
12 | |
12 | |
11 |