Taking a closer look at the measures, I just realized, you don’t need SUMX in any of them.
The measures return the accurate results as is in the Excel file you provided.
PVM walk through.pbix (44.6 KB)
Taking a closer look at the measures, I just realized, you don’t need SUMX in any of them.
The measures return the accurate results as is in the Excel file you provided.
PVM walk through.pbix (44.6 KB)