Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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) ?
Solved! Go to Solution.
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
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
For Correct DAX Pattern of Moving Average,
Please follow below links for exact solution.
Thanks & Regards,
Bhavesh
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |