Forum Discussion
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...
pls try this
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"))
Thank you
Unfortunately didn't work for me,the code doesnt give any errors but its not displaying the right numbers
share the file and show the target
Here is the data
Target is cal as
For eg : 2023 october target is calculated as 1.104 * Previous year(oct2022)
Year Month Cummulative Target Target cal 2021 October 1932261 2021 November 3569184 2021 December 5081362 2022 January 6442150 2022 February 7806165 2022 March 9541096 2022 April 11264768 2022 May 12992642 2022 June 14666883 2022 July 16334351 2022 August 18257345 2022 September 20333298 2022 October 2150459 2378613 1.231 2022 November 4016946 4393666 1.231 2022 December 5765406 6255157 1.231 2023 January 7710955 7930287 1.231 2023 February 9528877 9609389 1.231 2023 March 11717531 11745089 1.231 2023 April 13723072 13866929 1.231 2023 May 15755583 15993942 1.231 2023 June 17696324 18054933 1.231 2023 July 19648336 20107586 1.231 2023 August 21872357 22474792 1.231 2023 September 24179580 25030290 1.231 2023 October 2368976 2374107 1.104 2023 November 4472860 4434708 1.104 2023 December 6389242 6365008 1.104 why did you write this to the measure?
targets Ridership[PM] = "System Wide Ridership"