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
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"The column named PM has three metrics in that one of them is System wide ,this refers to this table.
Month Year Category PM Target Description Target Threshold - Green Target Threshold Yellow January 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 February 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 March 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 April 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 May 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 June 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 July 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 August 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 September 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 October 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 November 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 December 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 January 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 February 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 March 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 April 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 May 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 June 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 July 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 August 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 September 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 October 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.104 0.054 November 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.104 0.054 December 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.104 0.054 January 2024 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.104 0.054
you want to get the last year's sum (2150459) and then multiply by 1.104 ?
How to calculate the Target for october 2023=
Target = 1.104*2150459(october 2022 cummulative)
I wanted to get the TARGET
pls try this
this worked ,But I have to use the below measure ,which would take the value 1.104 and then I have to calculate the TARGET
SystemWide_Green = CALCULATE(MAX(targets_Ridership[Target Threshold - Green]), KEEPFILTERS(FILTER(ALL(targets_Ridership), targets_Ridership[PM] = "Systemwide Ridership")))The actual table is below one fro calcualting the above measure
Month Year Category PM Target Description Target Threshold - Green Target Threshold Yellow January 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 February 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 March 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 April 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 May 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 June 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 July 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 August 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 September 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 October 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 November 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 December 2022 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 January 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 February 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 March 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 April 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 May 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 June 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 July 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 August 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 September 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.231 0.181 October 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.104 0.054 November 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.104 0.054 December 2023 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.104 0.054 January 2024 Ridership Systemwide Ridership Increase from last year, with a 5% tolerance 0.104 0.05