Forum Discussion
Target Value KPI Targets
Did you try to make the calculation to the first date of the month instead of previous day?
I have a simolar setup and transform all the daily information to the same date that compares to the one in the target table.
Regards
Mfelix
Hi,
Measure used for different indicators and tables at the same repot page.
I do not see it possible at the moment.
I can't help you without further information can you please show some data or the way you calculate the Measure?
Measure:= SUMX(RELATEDTABLE(F_Inventory),F_Inventory[M2])
/
(CALCULATE(
IF(
COUNT(D_Date[DATE_Date])>=30,
SUM(F_Invoice[M2])
),
FILTER(
ALL(D_Date),
D_Date[DATE_Date]>(MAX(D_Date[DATE_Date])-30)
&& D_Date[DATE_Date]<=MAX(D_Date[DATE_Date])
)
)/30)With only the formula of this meaasure and not knowing what each value represents I can't do a lot but I notice that in the IF you do a Count of the DATE why are you using a count and not the actual date itself?