Filter a card visual / topN problem

[67nmark]

Hello,

I have created a simple parameter that I can successfully use to filter the table shown below. I am trying to make a card visual reflect the total displayed in the table (99000 - using a RankX measure and a filtered by measure) but I can't get the card visual to display the same value (showing 76000 - using a TopN measure). Can anyone help me fix this?

Cheers,

Mark

[67nmark · Accepted solution]

If it helps anyone in the future I got there with the help of this post:

Solved: Dynamically calculate differences based on slicer ... - Microsoft Power BI Community

Measure is: 

Total TopNumber Value = ABS(SUMX(FILTER(tblGroupsAdvisorValue, tblGroupsAdvisorValue[Rank Column] <= TopNumber[TopNumber Value]),tblGroupsAdvisorValue[Value]))