Forum Discussion
AdministratorAdd a column with measurement
What such a community
I have a doubt, I have a database in which the attendance of people is stored and through a formula which consists of several IFS and CALCULATES, which add and count the criteria of attendance can give us the total number of hours to pay a person for example:
Which I show on a table and thus be able to facilitate the payroll, the detail happens as seen in the table, the final result should be 16k hours, not 41k
There is some way in which this matrix can be added, line by line since I require the total of the sum of that matrix to be able to create a visualization by area
Any comments would be greatly appreciated
Best regards!
Please see this video for how to do this. Basically, you need an expression like this. It references your existing measure but will get you the same results in the rows and the correct "total".
NewMeasure = SUMX(VALUES([numeroEmpleado]), [Total Hours])
(2) Power BI - Tales from the front #01 - Getting the Right Total - YouTube
Pat
1 Reply
- mahoneypat
Microsoft Employee
Please see this video for how to do this. Basically, you need an expression like this. It references your existing measure but will get you the same results in the rows and the correct "total".
NewMeasure = SUMX(VALUES([numeroEmpleado]), [Total Hours])
(2) Power BI - Tales from the front #01 - Getting the Right Total - YouTube
Pat