May I ask something below?
We have line chart. When we right click on the line chart, we have “Analyze which leads us --> Explain the increase or Explain the decrease”. It didn’t work at Sumx measure. My measure is
Total Sales = Sumx(‘Detail Sales Order Lines’,’
Detail Sales Order Lines’[Quantity]*‘Detail Sales Order Lines’[UnitPrice])
So, I just created new calculated column and put in the line chart. It worked.
Therefore, I found out the Sumx didn’t work for analyze measure at line chart.
May I ask why it is?