Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
Currently I have in my card value the best customer, my objective is to display best customer's total amount too on the card below.
The chart is currently showing the sum of all values categorized by each customer.
I've tried to do the same measure as I did with best customer, but it's showing only one of the receipts of the customer, and instead I would like to show me the sum of it, so I was trying to get the value of total amount filtering by the card value given, but it doesn't show
I know in SQL it would be like:
SELECT SUM(MON_TOT)
FROM HIST_DOC
WHERE NOM_EMP = CARD_BESTCUSTOMER_VALUE (variable)
GROUP BY NOM_EMP;
Solved! Go to Solution.
maxx(filter(values(Table[customer]),[Rank]=1),Table[Customer] & " " & Table[Amount])
maxx(filter(values(Table[customer]),[Rank]=1),Table[Customer] & " " & Table[Amount])
User | Count |
---|---|
86 | |
82 | |
68 | |
67 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |