EMPTY GOAL IN KPI CARD

[Anonymous]

I Have this calculated table

ΠΙΝΑΚΑΣ ΔΙΑΓΡΑΜΜΑΤΟΣ2 = SELECTCOLUMNS(

{

     ("9/27/2022",231,648,661,763,175,2478,1),

     ("9/28/2022",261,416,644,709,179,2209,2),

     ("9/29/2022",255,725,606,545,218,2349,3),

     ("9/30/2022",265,565,565,570,189,2154,4),

     ("10/03/2022",383,659,490,746,100,2378,5),

     ("10/04/2022",383,659,589,746,141,2378,6),

     ("10/05/2022",212,588,561,605,148,2114,7),

     ("10/06/2022",248,533,585,578,133,2077,8),

     ("10/07/2022",197,463,468,571,102,1801,9),

     ("10/10/2022",332,602,511,807,157,2409,10),

     ("10/11/2022",230,523,552,811,138,2254,11),

     ("10/12/2022",243,565,616,718,130,2272,12),

     ("10/13/2022",252,606,623,783,148,2412,13),

    (HMNEWAPPS[ΗΜΕΡΟΜΗΝΙΑ ΑΝΑΦΟΡΑΣ],ACTIONS[TOTAL ACTIONS MIDDLE],[TOTAL ACTIONS NEW ORIGINATION CL],ACTIONS[TOTAL ACTIONS ML],[TOTAL ACTIONS BEST VALUE],[TOTAL ACTIONS GLA],[GRAND TOTAL ACTIONS],[SERIAL NO1])

    },

   "1.DATE",[Value1],

   "2.ACTIONS MIDDLE",[Value2],

   "3.ACTIONS NEW ORIGINATION CL",[ValUE3],

   "4.ACTIONS ML",[Value4],

   "5.ACTIONS BEST VALUE",[Value5],

   "6.ACTIONS GLA",[Value6],

   "7.GRAND TOTAL ACTIONS",[Value7],

   "8.SERIAL NO",[VALUE8]

)

and to measures one 

ACTIONS TOTAL = CALCULATE(MAX('ΠΙΝΑΚΑΣ ΔΙΑΓΡΑΜΜΑΤΟΣ2'[7.GRAND TOTAL ACTIONS]),FILTER('ΠΙΝΑΚΑΣ ΔΙΑΓΡΑΜΜΑΤΟΣ2',MAX('ΠΙΝΑΚΑΣ ΔΙΑΓΡΑΜΜΑΤΟΣ2'[1.DATE])))

This is the value in the KPI card

and

2nd 

GRAND TOTAL ACTIONS PREVIOUS DAY =

var parametros=  MAX('ΠΙΝΑΚΑΣ ΔΙΑΓΡΑΜΜΑΤΟΣ2'[8.SERIAL NO])-2

VAR CORRECTDATE = CALCULATE(MAX('ΠΙΝΑΚΑΣ ΔΙΑΓΡΑΜΜΑΤΟΣ2'[1.DATE]),FILTER('ΠΙΝΑΚΑΣ ΔΙΑΓΡΑΜΜΑΤΟΣ2','ΠΙΝΑΚΑΣ ΔΙΑΓΡΑΜΜΑΤΟΣ2'[8.SERIAL NO]=parametros))

VAR CALC1=CALCULATE([ACTIONS TOTAL],FILTER('ΠΙΝΑΚΑΣ ΔΙΑΓΡΑΜΜΑΤΟΣ2','ΠΙΝΑΚΑΣ ΔΙΑΓΡΑΜΜΑΤΟΣ2'[1.DATE]=CORRECTDATE))

return CALC1

thiw is the trend

but the goal in the kpi card is blank

[Anonymous]

Hi @Anonymous 

Can you provide a pbix file or data sample for us ? It's a bit difficult to restore your problem from the information you provided .

Best Regards,
Community Support Team _ Ailsa Tao