Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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])