Showing results for 
Search instead for 
Did you mean: 
Regular 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. 



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



(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.

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

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors