Forum Discussion

Bladimir's avatar
Bladimir
Icon for Helper I rankHelper I
6 years ago
Solved

Sum with calculate

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...
  • kentyler's avatar
    6 years ago

    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.