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.
I have two datasets that were pulled together (via append). I had to append instead of make a measure, etc to make other calculations work.
Ex Dataset looks something like this:
I have multiple Opportunity IDs but I'm trying to get the SUM of DISTINCT VALUES so used the calc below. It works as expected at the row level but goes wonky when it gets to the subtotal value.
Total Sales_SUMx/DISTINCT =
SUMX (
(DISTINCT('Sales'[Opportunity ID])) , MAX('Sales'[Total Sales Amount])
)
Solved! Go to Solution.
Hi @Pam ,
You can create a new measure to be placed on the visual object instead of the old measure.
NewMeasure = SUMX(VALUES('Sales'[Opportunity ID]),[Total Sales_SUMx/DISTINCT])
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-tangjie-msft
Neeko Tang,
That did it! Thank you for your help, I really appreciate it!
Hi @Pam ,
You can create a new measure to be placed on the visual object instead of the old measure.
NewMeasure = SUMX(VALUES('Sales'[Opportunity ID]),[Total Sales_SUMx/DISTINCT])
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
52 | |
46 | |
20 | |
16 | |
13 |
User | Count |
---|---|
108 | |
56 | |
31 | |
19 | |
18 |