Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Summarizing data

Hello All, I have created one column in PBI, which gives Fees amount . The dax is below FEES_CALCULATED = SWITCH( TRUE(), PARTS[FLAG]="PT", IF( NOT(ISBLANK([A_FEES_VALUE])) && [A_FEES_VALUE]...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.