Forum Discussion
Solved
Filter a card visual / topN problem
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
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]))
1 Reply
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]))