Measure calculating the overall rows of a table

[LuisGerardoSR]

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]

@LuisGerardoSR 

Try something along the lines of:

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

[LuisGerardoSR]

it worked perfect.

Thanks a lot!