Forum Discussion

Himaja95's avatar
Himaja95
Helper I
2 years ago
Solved

Powerbi

Hi   I am getting this error,when i am trying calculate the targets error: Calculation error in measure targets_Ridership(Bus _Ridership_Green):A table of multiple values were supplied ,where a s...
Need Help
Ahmedx's avatar
Ahmedx
Super User
2 years ago

pls try this

 

 

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"))

 

 

Ahmedx's avatar
Ahmedx
Super User
2 years ago

and try this

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"))