Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
Syndicate_Admin
Administrator
Administrator

calculated columns and measures

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.

BricioJ_1-1687809727717.png

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.

0 REPLIES 0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! It's time to submit your entry.

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.