Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm trying to do something that is probably quite simple but I can't get my head round.
I have a Card visual that shows the total cost for a data set, linked to a filter over Work Number.
The table behind the visual is a detail transaction listing codes allocated to each work number along with a cost (screenshot of example records attached) - there can be multiple records per worknumber.
The actual cost is held per worknumber on a the header table and included in the detail as Column analysisActualPartsCost = RELATED(worksorderhdr[actual_parts_cost]) .
The problem I have is when i apply the filter the value of all the lines are summed, whereas in my example, when filtering by WO-020964 the visual should show a cost of 64.8, but instead it shows 3 x 64.8 (as there are 3 records).
Solved! Go to Solution.
Hi @garycarters ,
I'm a little confused about your scenario.
If I understans your total cost correctly that it is a measure like below.
total cost = CALCULATE(SUM('Table'[Cost]))
If so, I think the card behaviour is correct.
If you only want to show the 64.8 when the selectedvalue is WO-020964, you could use the measure like this.
total cost = CALCULATE(MAX('Table'[Cost]))
In addition, there are four records for 64.8 in your image.
If you still need help, free to ask and please share your data sample as table format so that we could have a test on it.
Best Regards,
Cherry
Hi @garycarters ,
Have you solved the problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, free to ask.
Best Regards,
Cherry
Hi @garycarters ,
I'm a little confused about your scenario.
If I understans your total cost correctly that it is a measure like below.
total cost = CALCULATE(SUM('Table'[Cost]))
If so, I think the card behaviour is correct.
If you only want to show the 64.8 when the selectedvalue is WO-020964, you could use the measure like this.
total cost = CALCULATE(MAX('Table'[Cost]))
In addition, there are four records for 64.8 in your image.
If you still need help, free to ask and please share your data sample as table format so that we could have a test on it.
Best Regards,
Cherry
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |