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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
BricioJ
Frequent Visitor

Measures and calculated columns

i need to do this simple formula (A1/A2)*A3, A1 represent the hour, A2 the sum of all the hours and A3 the value assigned to it depending on the type (SMB, OTHERS CORP) .

i already made it but using some measures and calculated columns, now the problem that i realized is that i can't use filters with the calculated columns, to get the total of hours I use a calculated column to make the operation with all the columns with the individual hours and the values of SMB, OTHERS and CORP, as you notice the general is 29 but if i filter by the date the total of hours decrease but the fields keep the value because i use a calculated column and it doesn't change. 

 

BricioJ_0-1686333820032.png

(Here using 29 hours as the total, the calculations are correct, even percentage total gives 100%)

BricioJ_3-1686334121672.png

 

(But if i change the date the total of hours change and the calculations continue to be made under the data of the previous total, and the percentage total doesn't gives 100%)

and the fields below still the same because they are made by calculated columns so they will never change, but i need them to change, the sum of them should give the total of hours that in this case is 14 not 29)

pls someone help me.

1 REPLY 1
lbendlin
Super User
Super User

You are right - as soon as the results of a computation must be influenced by a user's interaction with your report then you need to use measures. 

 

Start over and implement your logic with measures.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.