IF formula with multiple conditions

v-qiuyu-msft,

a lady from the MS support gave me a solution that seems ok :

---

"

Hi Augustin,

Here are the measures that you will need:

1. SelectedValue = IF (ISFILTERED ( Example[Indicator1] ) && HASONEVALUE ( Example[Indicator1] );LASTNONBLANK ( Example[Indicator1]; 0 );"a default value");
2. SumValues = SUM(Example[Values]);
3. VarKPI2MonthlyTGTR = IF([SelectedValue]="WS"; AVERAGE(Example[Values]); [SumValues]);

In will need to substitute what is in orange with your dimensions.

And here are some interesting documentation:

 https://msdn.microsoft.com/en-us/library/ee634396.aspx;
http://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/;

"

---