Hello, I am experiencing a new function within a Matrix Visual and cannot determine where the vlaues are coming from. I have a DAX formula to calcualte a 3 month average.
3mth Avg = CALCULATE(SUM('ARTransactiontbl'[Positive Amount]),DATESINPERIOD('Date'[Date],LASTDATE('Date'[Date]),-3,MONTH))/3
I also have the matrix and a chart to show the results.
This is as predicted but when I click the row again I get a second set of numbers in the chart. I cannot seem to find where this result is from. Any Ideas?
Thank you!
HI, @Anonymous
How do you do that " I click the row again"? It seems that there is some interaction between the visuals.
Could you share your sample pbix file for us to have a test
Best Regards,
Lin
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.
User | Count |
---|---|
234 | |
49 | |
48 | |
48 | |
43 |
User | Count |
---|---|
290 | |
241 | |
137 | |
84 | |
69 |