sum table

[TatyDo]

Hallo everyone,

I have this measure 

WA fix1 = (IF([Total sale ]=BLANK(),[Target% ],[Target2%])

All of these measures are using the same table.

Target2 is a target weighted average of the total sale

Target% is the target sale. 

In this measure I want to show, if there was no sale then put the target, if there is sale then put the weighted target sale. 

I am getting the correct vales in the rows, however the total of the measure is not considering the value of [Target% ]. 

Could someone help out there?

[amitchandak · Accepted solution]

@TatyDo , You have to create a formula like this at visual group/row/axis or some ID level

sumx(values(Table[Group]) ,IF([Total sale ]=BLANK(),[Target% ],[Target2%]))

sumx(values(Table[Group]) ,IF([Total sale ]=BLANK(),[Target% ],[Target2%]))