Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Powerbi

Hola Recibo este error, cuando estoy tratando de calcular los objetivos error: Error de cálculo en la medida targets_Ridership(Bus _Ridership_Green): Se proporcionó una tabla de valores múltipl...
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Por favor, pruebe esto

SystemWide_Green =
 CALCULATE(Max(targets_Ridership[Target Threshold - Green]),
    KEEPFILTERS(FILTER(ALL(targets_Ridership), 
      targets_Ridership[PM] = "Systemwide Ridership")))
-------or-----------------------
SystemWide_Green =
 CALCULATE(Max(targets_Ridership[Target Threshold - Green]),
        FILTER(ALL(targets_Ridership), 
              targets_Ridership[PM] = "Systemwide Ridership"))
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

y pruebe esto

SystemWide_Green =
 CALCULATE(SUM(targets_Ridership[Target Threshold - Green]),
    KEEPFILTERS(FILTER(ALL(targets_Ridership), 
      targets_Ridership[PM] = "Systemwide Ridership")))
-------or-----------------------
SystemWide_Green =
 CALCULATE(SUM(targets_Ridership[Target Threshold - Green]),
        FILTER(ALL(targets_Ridership), 
              targets_Ridership[PM] = "Systemwide Ridership"))