October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
Hi,
I have this field (surv_quantity) but a job level in my table surv_jobs
I have this field (surv_out) at a sub job level in my table surv_sub_job
What I need to do it take the surv_jobs.surv_quantity - surv_sub_jobs.surv_value
The problem I have is that the value surv_quantity double counts as it see 2 jobs as it has 2 sub jobs.
Example-
Surv_id=10
surv_quantity I have a total value of 30,000
However, if I look at the detail whereby job
Surv_id=10
Surv_sub_id=12 value=30000
Surv_sub_id=23 value=30000
By having 30000 twice, it's scewing the numbers as it thinks for that job, the value is 60000 when in actual fact, its 30000.
Any idea how I can get around this please so it only takes the one value?
Solved! Go to Solution.
pls check if this is what you want
Proud to be a Super User!
then what's the expected output? 12 is 15000 and 23 is 15000?
Proud to be a Super User!
Yes, that's right
you are welcome
Proud to be a Super User!
Hi @M_SBS_6
This looks like an interesting problem
Is there any way you can provide data that demonstrates the problem with sensitive data removed? (a pbix would be preferable)
Also, please provide expected results and an explanation of any intermediary steps needed in the calculation.
User | Count |
---|---|
105 | |
99 | |
98 | |
86 | |
49 |
User | Count |
---|---|
162 | |
142 | |
132 | |
102 | |
63 |