I have a inconvenent to obtein one calculated column doing two operations, one of sum and other of division as I show in this image:
Resulted must be agregated to one table of visualization type matriz.
In the before picture the operation is for each row:
Row 1) 41 * 18 / 253 = 3 (value is round)
Row 2) 100 * 18 / 253 = 7
Row 3) 103 * 18 / 253 = 7
Row 4) 9 * 18 / 253 = 1
Note: Column CxIndex and #Pac Fallecidos are obteined with a messure for each one.
Go to Solution.
Place this measure in the table visual you show above
VAR aux1_ = CALCULATE ( [CxIndex], ALL ( Table1[Grupo_Etario] ) )
VAR aux2_ = CALCULATE ( [Pac Fallecidos], ALL ( Table1[Grupo_Etario] ) )
DISTINCT ( Table1[Grupo_Etario] ),
ROUND ( DIVIDE ( [CxIndex] * aux2_, aux1_ ), 0 )
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
View solution in original post
Click here to learn more about the September 2022 updates!
Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!