KPI target is empty (because of previous period in measure?)

[ammeijs]

Hi all, 

I am trying to figure out what is going wrong with my KPI visual. I suspect it is how I set up my measure where I added an argument that extracts the values from the previous period. 

I use two measures: 

- One where I calculate the reach from current period: 

Bereik pp FB = CALCULATE(SUM(Facebook[Bereikte_personen])/COUNTROWS(Facebook),ALLSELECTED(Facebook))

- One where I calculate the reach from previous period: 

Bereik pp FB vorig = CALCULATE(SUM(Facebook[Bereikte_personen])/COUNTROWS(Facebook), DATESBETWEEN(Kalender[Date],[Start vorige periode],[Einde vorige periode]),ALLSELECTED(Facebook))   

The information I used to create the measures for calculating the previous period. Maybe I did something wrong here: https://bit.ly/2VS3IiC 

Anyway, the measures are showing correctly in the tables below. However, not in the target of the KPI visual.  

 However, when I change the measure for the previous period to this: 

Bereik pp FB vorig = CALCULATE(SUM(Facebook[Bereikte_personen])/COUNTROWS(Facebook), DATESQTD(DATEADD(Kalender[Date],-1,QUARTER)))   

 The target is showing the correct value.

I prefer to be not stuck with the quarter measure as a previous period, and want it more dynamic. And to be free to compare with month, quarter, year or day if I please. So, that is why I want the first measure to work. Does any of you have some insight in how to achieve this? 

Thank you all in advance. 

[ammeijs]

It's a shame @Anonymous, the solution did not work. Via this link you can download the sample .pbix file: https://1drv.ms/u/s!Ahb0NmLgiaIQpl4OQEQP7o-BVsl-?e=i441bZ. Does it work? I hope you can make some sense out of it. Thanks in advance!  

[Anonymous]

Hi  @ammeijs ,

You can use this measure:

Bereik pp FB vorig = CALCULATE(SUM(Facebook[Bereikte_personen])/COUNTROWS(Facebook),filter(ALLSELECTED(Kalender), Kalender[Date]>= [Start vorige periode] && Kalender[Date]<= [Einde vorige periode])) 

If my results do not meet your expectations，can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.