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,
I'm simply trying to find an efficient way to calculate the grand total of a column with conditional measures.
In this particular case we have May and June sales data in 2 different tables which are joined by the country column. When June data are missing , the blank cells are calculated using the May data. (june sales = may sales x 0.5). (see below)
The problem is that the total ($10000) of the "Calculated Junes Sales" column is wrong. I have tried to used SUMX to resolved this issue with no success. The difficulty comes from the fact that May and June data are in 2 different tables.
Thank you for your help.
@Anonymous , Assume you have measure [May Sales], Try like
sumx(Values(Table[Country]), [May Sales]* .5)
User | Count |
---|---|
91 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
99 | |
88 | |
72 | |
60 | |
59 |