Create measure as per referred column value

[jeongkim]

Hi,

I have a table and it has 10k rows data. 

The data is calculated by KPI Title.

Hope if the Unit is [%] then calculate for average, if not then calculate for sum. 

Pls help me to make measure. 

[Daniel29195 · Accepted solution]

Hello @jeongkim, 

hope you are doing great, 

 i think you can use a switch ( true () ,  statement with selectedvalue  

so example : 

switch (

true() ,

selectedvalue(tablename[unit]) = "[%]" , average ( col ) , 

sum ( col )

)

hope this helps.