Question about Card Function

[Anonymous]

I created a table that includes:

Work Order, Part Number, and among others a calculated column "Standard Rate".

The table lists the Standard Rate for each work order.  The problem is I want to create a "Card" that has the overall Standard Rate foa any items selected.  The problem is that is sums up the indivitual rated, rather than giving me one overall rate for any selected items.  How do I fix this?

[MFelix · Accepted solution]

Hi @Anonymous,

You need to make the Standard Rate a measure and not a calculated column.

If you give any additional information I can help you rewrite the calculated column to measure.

Regards,

MFelix

[Anonymous]

It worked!  Why?

[MFelix]

Hi @Anonymous,

Measures are based on context so when you make a measure depending on your visuals information the calculation are made accordingly.

When you make the calculation for a column it only considers the row context so the result will be the sum or average that is not the correct value.

Regards
MFelix