Forum Discussion
Summarizing data
Hi Anonymous ,
I tried to reproduced your data.
Here's my sample data and the calculated column.
By default, the card visual displays an aggregate value.
To avoid summing up the values, you can create a measure that calculates the FEES_CALCULATED for a specific ID. Here’s an example of how you can create such a measure:
FEES_CALCULATED_MEASURE=MAX ( 'PARTS'[FEES_CALCULATED] )This measure will return the maximum FEES_CALCULATED value for the selected ID, ensuring that the card visual displays the correct value.
If the problem is still not solved, please provide some dummy data and the desired result to show your formula operation, thank you.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserHi Anonymous
Try with this measure.
FEES_CALCULATED =
SWITCH(TRUE(),
PARTS[FLAG] = "PT",
IF(NOT(ISBLANK([A_FEES_VALUE])) && [A_FEES_VALUE] <> 0,
[A_FEES_VALUE],
IF(
NOT(ISBLANK([A_FEES_MCA])) && [A_FEES_MCA] <> 0,
[A_FEES_MCA],
[A_FEES_LTS])),
BLANK())
FEES_DISPLAY =
SELECTEDVALUE(FEES_CALCULATED, BLANK())
Let me know if it works.
Hi, Thanks for replying.
It's giving blank values if i didn't select any filter.
It should be like if I didn't select anything it should summate values from Flag= PT and give total value, but not duplicate
Morever I created both FEES_CALCULATED & FEES_DISPLATED as Columns, in measure it giving some errors
Please reply back