Range Slicer + Dynamic KPIs

[Anonymous]

Hi All,

I am trying to do a dynamic KPI that would depend on the dates selected in the slicer. The problem I have is that When I select a single month, the values are being displayed correctly but when selecting a single Month but never being aggregated when selecting more than 1 month.

The formulas are just standard sth like:

1.Calculate(distinctcount(table[id]),dim_dates(full_date))
2.calcuate(distinctcount(table[id]),sameperiodlastyear(full_date))

within the kpi I have:

1. First Formula

2. MonthName

3. Second Formula

Thank you for your help!

[v-jiascu-msft]

Hi @Anonymous,

Please share a sample. Your image is corrupted.

What kind of "aggregated" do you expect? You have a month in the KPI. Can the aggregation be applied more than one month?

Best Regards,

Dale

[Anonymous · Accepted solution]

Hi Dale,

The data was meant to be aggregated monthly with a slicer allowing to select a specific range of months, not sure what's not clear. It looked like SAMEPERIODLASTYEAR had some problems in my case scenario and used PARALLELPERIOD function instead which worked perfectly.

Thanks!