Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone,
I have data set of Countries, Products, Supply and Demand value, I created a measure call " Supply Possibility"=Supply-Demand.
Then I want to separate negative and possible value into 2 measures and the right Sum will shown up in Total Row.
I already tried some suggestion to calculate the number but just show as attached picture with WRONG TOTAL, it should be something like BLUE and RED
Solved! Go to Solution.
@ChiVi , Create a measure on top of your measure and use
Sumx(Sumamrize(Table, Table[Country], Table[Product], "_1", [Current Measure]), [_1])
@ChiVi , Create a measure on top of your measure and use
Sumx(Sumamrize(Table, Table[Country], Table[Product], "_1", [Current Measure]), [_1])
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |