Help with showing count for last month by default

[franorio]

Hi everybody, 

got a report, in which the main columns i use are:.

Status: Completed / Not Completed

Scope: Yes / No

Gente a Cargo: Personal ID if applies.

Month: January 2017 / Febreuary 2017 / March 2017... etc

I don´t use a Dim Calendar Table because i don't use specific dates. Just a column for Month & Year.

I use the following Measure to calculate which persons got the Leading training completed.

Leading Completed Scope = CALCULATE(
COUNTROWS(leading) ,
FILTER(
'leading',
'leading'[Status]="COMPLETED"
&& leading[Scope]="YES"
&& NOT ISBLANK(leading[Gente a cargo])
)
)

As you can see on the below screens, I caluclate Total Scope, If it's completed or not, and the % of completition.

Until a few days ago, I needed the report done this way, to see the YTD. So if i didn't used the above slicer for month (Enero = January, Febrero = february, etc), I was getting the acumulated as i needed.

In case i would like to see info for certain month, i selected the Month (Abril  = April) and got all numbers i needed for that specific period. Main issue is the method of calculation and interpretation of KPI's changed. So what I need to see is, If i don't select any month on the above slicer, insted of seeing the YTD (acumulated), need to bring by default the last picture or last month that was updated with info. For example if today (July), I don't select anything on the Month Slicer... information for those formulas should bring me by default the numbers as if June (or last month with charged information) would be selected. 

Thanks in advance!!

Regards!!

[v-chuncz-msft]

@franorio,

You may try to use ISFILTERED Function inside the IF Function.