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.
Hello!
If I'm dividing two measures, I end up with a strange result. I have the following data:
Aanvraag nr (consider it a salesorder number)
Total send per aanvraag nr
Total used per aanvraag nr
Customer name (not included in the screenshot)
Contact person name (not included in the screenshot)
For the number send (verzonden) and used (gebruikt) I simply count the number of rows for the aanvraag nr and this returns the right value:
When I try to calculate the percentage (used/send), it combines the number of send vouchers per contactperson.
What should I do to avoid this? Clearly, 1 divided by 1 is not 0,07%. 1 divided by 1350 is tough.
Thanks!
Solved! Go to Solution.
It seems that your Vouchers table does not have a join with "Aanvraag nr" table. try to create one.
Try to put "Anatal verzonden vouchers" in the table and see the results.
Proud to be a Super User!
It seems that your Vouchers table does not have a join with "Aanvraag nr" table. try to create one.
Try to put "Anatal verzonden vouchers" in the table and see the results.
Proud to be a Super User!
Thanks for the help. The relationship itself can't be the isue, since all data originates from the same table. Reviewing this did help me find the solution tough, I had to use the aanvraagnr from the table were this number is the primary key.
Problem solved, thanks for the help 🙂
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
54 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |