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.
My need is simple : I have different lines which I want to multiply and I need a global KPI summed by month.
I created a measure : Amount = PRODUCTX(Feuil1,Feuil1[Value])
But of course I'm not specifying how to add that amount up and by default Power BI does a grand total with each row multiplied.
I need some help. Thanks in advance.
Solved! Go to Solution.
@lhdp , Try measures like
sumx(values(Feuil1[Month]), calculate(PRODUCTX(Feuil1,Feuil1[Value])))
or
sumx(values(Table[Month]), calculate(sumX(filter(Table, [Variable] ="Qty"), [Value]) * Maxx(filter(Table, [Variable] ="UnitPrice"), [Value])))
Thanks to you. The 2 solutions run wells. It depend if we want to specify the product or not between variables.
@lhdp , Try measures like
sumx(values(Feuil1[Month]), calculate(PRODUCTX(Feuil1,Feuil1[Value])))
or
sumx(values(Table[Month]), calculate(sumX(filter(Table, [Variable] ="Qty"), [Value]) * Maxx(filter(Table, [Variable] ="UnitPrice"), [Value])))