Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Reply
Bladimir
Helper I
Helper I

Sum with calculate

‎01-07-2020 07:21 AM

Hola

 

Estoy usando medidas calculadas en power bi y obtenido la siguiente tabla:

CHR - KM*SCORE = [SUMA KM (CHR)]*[CHR - SCORE (SIN PONDERACION)]
SUMA KM (CHR) = CALCULATE(SUM('RANKING FACTOR CONDUCCION SEGURA (SOLO CHR)'[KM TOTAL]))
 
EV - KM*SCORE = [SUMA KM (EV)]*[EV - SCORE (SIN PONDERACION)]
SUMA KM (EV) = CALCULATE(SUM('RANKING FACTOR CONDUCCION SEGURA (SOLO EV)'[KM TOTAL]))
 
....
 
ZONAOLKMCHR - KM*SCORE03 HR - KM*SCOREEV - KM*SCOREMP - KM*SCORE10 HR - SCORE*KMDNA - SCORE*KM
BAMBAS449407.74465714.5695777208.063900843557.8440
BAMBAS4521235.75812160.3631102506.272001922655.1560
SUR506027.970437910.30650602797602797554787.0496
NORTE625371.020398533.42220537102364729.0936449098.5944
BAMBAS681212.4766948.5628372247.792031257.3121247121247105246.9268
SUR6815155.5201061439.3970151555215155520
SUR703796.2311673.15467329007.5308379623379623379623379623
ANTAMINA11619104.73019104730191047319104731686459.603
LIMA1168722.61872261 0872261872261824244.1688
NORTE1168507.170249841.33570850717735620.6097698742.936
TOROMOCHO116383.7138371 0383713837138371
BAMBAS11713162.96488478.48861082553.935001299331.7671004306.146
SUR117965.77096577096577965770
CENTRO1203413.873413873413870341387334380.5693277393.972
NORTE12047.46047464746474647460
SUR1201023.58069326.12161010235810235814368.616
BAMBAS1215013.16139306.2213251369.1268201226.985013165013160
CENTRO1213443.050252088.51060344305264944.1495176323.7544
LIMA1211507.96150796 0150796150796150796
NACIONAL12112423.431182049.2112423431212502.36124234312423431178336.614
CENTRO1228478.710423999.4870847871847871647894.1164
NORTE1229438.3900900900900900
BAMBAS1241953.4597272.8485819534501953451953450
NACIONAL1245424.7175358.73802394064.20890542471433841.5923222510.2856
SUR1241253.4824393.1312679627.47751012534812534853358.8156
SUR13519155.501579324.272019155501619027.2271507550.367
BAMBAS1451883.5401883540188354188354132350.256
NORTE1633865.97299115.9271386597386597386597386597386597

 

QUIERO APLICAR AL SIGUIENTE LOGICA PARA OBTENER LA SIGUIENTE TABLA:

 

DESEMPEÑO EV= SUMA (EV - KM*SCORE)  /  SUMA (KM)

DESEMPEÑO CHR = SUMA (CHR - KM*SCORE)  /  SUMA (KM)

DESEMPEÑO MP = SUMA (MP - KM*SCORE)  /  SUMA (KM)

...

 

INDIVIDUOCHR - KM*SCORE03 HR - KM*SCOREEV - KM*SCOREMP - KM*SCORE10 HR - SCORE*KMDNA - SCORE*KM
TODAS LAS ZONAS-OL27.8412203271.0510157412.0189414175.9239764793.9868872557.64896534

 

 

Saludos.

 

 

Message 1 of 2
607 Views
0
1 ACCEPTED SOLUTION
kentyler
Solution Sage
Solution Sage

‎01-12-2020 06:31 AM

Parece que queire construir una table con un record que contiene sumas para la tabla de ejemplo.

https://radacad.com/creating-a-table-in-power-bi-using-dax-table-constructor

este articulo descirbe como hacerlo in DAX.  Tienia que escribir una medida para cada columna, pero las medidas pueden hacer qualquier calculacion .

 

Soy un personal Power Bi Trainer  aprendo cada vez que respondo a una pregunta

The Golden Rules for Power BI

  1. Use a Calendar table. A custom Date tables is preferable to using the automatic date/time handling capabilities of Power BI. https://www.youtube.com/watch?v=FxiAYGbCfAQ
  2. Build your data model as a Star Schema. Creating a star schema in Power BI is the best practice to improve performance and more importantly, to ensure accurate results! https://www.youtube.com/watch?v=1Kilya6aUQw
  3. Use a small set up sample data when developing. When building your measures and calculated columns always use a small amount of sample data so that it will be easier to confirm that you are getting the right numbers.
  4. Store all your intermediate calculations in VARs when you’re writing measures. You can return these intermediate VARs instead of your final result  to check on your steps along the way.




Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


View solution in original post

Message 2 of 2
542 Views
0
1 REPLY 1
kentyler
Solution Sage
Solution Sage

‎01-12-2020 06:31 AM

Parece que queire construir una table con un record que contiene sumas para la tabla de ejemplo.

https://radacad.com/creating-a-table-in-power-bi-using-dax-table-constructor

este articulo descirbe como hacerlo in DAX.  Tienia que escribir una medida para cada columna, pero las medidas pueden hacer qualquier calculacion .

 

Soy un personal Power Bi Trainer  aprendo cada vez que respondo a una pregunta

The Golden Rules for Power BI

  1. Use a Calendar table. A custom Date tables is preferable to using the automatic date/time handling capabilities of Power BI. https://www.youtube.com/watch?v=FxiAYGbCfAQ
  2. Build your data model as a Star Schema. Creating a star schema in Power BI is the best practice to improve performance and more importantly, to ensure accurate results! https://www.youtube.com/watch?v=1Kilya6aUQw
  3. Use a small set up sample data when developing. When building your measures and calculated columns always use a small amount of sample data so that it will be easier to confirm that you are getting the right numbers.
  4. Store all your intermediate calculations in VARs when you’re writing measures. You can return these intermediate VARs instead of your final result  to check on your steps along the way.




Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Message 2 of 2
543 Views
0

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

FabCon and SQLCon Highlights Carousel

FabCon &SQLCon Highlights

Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.

View All