Measure calculating the overall rows of a table

[Anonymous]

Hello everyone,

I have a measure that is calculating the "% Expend" for each of the rows in the table. However, when no row is selected, the measure calculates the overall "% Expend".

I would like this measure to show no calculation at all for the overall and just show the value when any of the rows are selected.

Thank you!

[PaulDBrown · Accepted solution]

@Anonymous 

Try something along the lines of:

selected row = IF(ISFILTERED(Table [field]), [% Expend])

[Anonymous]

it worked perfect.

Thanks a lot!