Forum Discussion

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
9 years ago
Solved

KPI Visual: empty "Goal" and "+Infinity%"?

Good Afternoon,

 

There must be an obvious reason but I cannot fathom it out. I am trying to include a KPI visual which compares YTD sales figures with Previous YTD sales, but I get and empty comparison.

Here is the screenshot:

 

The two boxes underneath are the measure reflecting both current and previous year YTD sales numbers.

The trend axis is "year".

 

Any pointers??

 

Thank you very much for your help!

 

regards

Paul.

Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago

    PaulDBrown

    Thanks for sharing the pbix. Add ALL to the filter to exclude any filter context.

     

    Sales YTD = calculate(sum('Campañas2'[Facturación Real]),
	Filter(ALL(YearMonth),
	YearMonth[month]<= MONTH(TODAY())
	&&
	YearMonth[year]=YEAR(TODAY())
	))

Sales MonthTD Previous Year = calculate(sum('Campañas2'[Facturación Real]),
	Filter(ALL(YearMonth),
	YearMonth[month]= MONTH(TODAY())
	&&
	YearMonth[year]=YEAR(TODAY())-1
	))

     

     

7 Replies

      • Eric_Zhang's avatar
        Eric_Zhang
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        PaulDBrown

        You can upload a pbix file to Onedrive or any web storage and share the link. Do mask sensitive data before uploading.