Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

KPI - Goal: (Blank) (+Infinity %)

 am trying to compare this week sales and last week sales. My Year Week column is text and not a date field.

 

I have two calulcated columns:

 

ThisWeek = MAX([Year Week]) 

 

LastWeek = CALCULATE(MAX([Year Week]), filter('MK_PAPA_CREDIT_PENETRATION_REPORTING_SERIES', [Year Week]<>MAX([Year Week])) )

 

I have two calculated measures:

 

ThisWeekCreditSales = calculate(sum(MK_PAPA_CREDIT_PENETRATION_REPORTING_SERIES[Credit Sales]),filter('MK_PAPA_CREDIT_PENETRATION_REPORTING_SERIES',[Year Week]=[ThisWeek]))

 

LastWeekCreditSales = calculate(sum(MK_PAPA_CREDIT_PENETRATION_REPORTING_SERIES[Credit Sales]),filter('MK_PAPA_CREDIT_PENETRATION_REPORTING_SERIES',[Year Week]=[LastWeek]))

 

When I put this into a KPI with this week sales as the indicator, last week sales as the target and year week as the trend axis I get Goal: (Blank) (+Infinity%) instead of Goal: Last Week Sales and then the % difference.

 

It effectively should look like a combination of the figures on the picture below.

 

  

 

Need Help

3 Replies

  • v-xjiin-msft's avatar
    v-xjiin-msft
    Solution Sage
    8 years ago

    Hi Anonymous,

     

    With only expressions, it is hard for us to understand your requirement. Please share us more information like your source table structure and some sample data with expected result. 

     

    Thanks,
    Xi Jin.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi v-xjiin-msft

       

      I have added some pictures of the data and a clearer picture of what I would like the KPI to look like 

       

      Thanks.

      • v-xjiin-msft's avatar
        v-xjiin-msft
        Solution Sage
        8 years ago

        Hi Anonymous,

         

        Screenshot helps nothing. Please kindly share us your pbix file with One Drive or Google Drive. So that we can dig deeper and make some proper tests.

         

        If you can't share us your file. Please attach some sample data which we can copy and paste directly and its corresponding expected result.

         

        Thanks,
        Xi Jin.