Context filter for measure

[alissker]

I created a Moving Average Measure like 

MA (7) = CALCULATE(sum(Item[Valor]);DATESINPERIOD('Calendar'[Date];LASTDATE('Calendar'[Date]);-7;DAY))/(CALCULATE(AVERAGE('Working_days'[DU_7])));

But it doesn´t correspond to my context filter. Whe I select some columns it still giving me the same results. I have two other columns I would like to slice (Product, Client).

How can I use context filter to my calculated field  (column or measure) ?

[v-ljerr-msft · Accepted solution]

@alissker

---

How can I use context filter to my calculated field  (column or measure) ?

---

How context filter works depends on the relationships between your tables.  What are the relationships between your tables? Based on DAX, it should have no issue on your calculation logic. Could you post your table structure and some sample data in your case? It's better if you could upload a pbix file.

References:

Row Context and Filter Context in DAX

Create and manage relationships in Power BI Desktop

Regards

[BhaveshPatel]

For Correct DAX Pattern of Moving Average,

Please follow below links for exact solution.

Link 1

Link 2

Link 3

Thanks & Regards,

Bhavesh