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 R...
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]))
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]))