Fixed percentage number from related table

[Analitika]

So main table is

Name | Code | Sum | Count 

asdd | zz | 231 | 2

dfsfds | x  | 523 | 2

myt | y | 768 | 5

Related Table

% | Code

0,05 | x

textVal1 | y

textVal2 | z

0,05 | zz

0.1 | aa

I have measure wich calculate some percentage

measureSome% = divide(Sum, Count)

Then i have second measure where use this percentage

measureMain = [measure1] - [measure2] * measureSome%

Now, i need write new measure to take dinamicaly perecentage from related table if meet criteria

measureDinamicPercentage =

IF ( isDecimal(RelatedTable[%]) = True then 

RelatedTable[%]

else

if(RelatedTable[%] = textVal1 then 0.06 else [measureSome%])
)

So main measure must be
measureMain = [measure1] - [measure2] * measureDinamicPercentage

So have to write measureDinamicPercentage ?

[v-diye-msft]

Hi @Analitika 

If I'm correct, you might refer to these results:

measureDinamicPercentage = IF(IFERROR(VALUE(MAX('Table (2)'[%])),1)=1&&MAX('Table (2)'[%])="textVal1",0.06,IF(IFERROR(VALUE(MAX('Table (2)'[%])),1)<>1,MAX('Table (2)'[%]),[measureSome%]))

 

Pbix attached.

[Analitika]

TY for reply.

measureSome% = TotalCount / TotalSum

and same for each row,

[v-diye-msft · Accepted solution]

Hi @Analitika 

this one?

measureSome% = DIVIDE(SUMX(ALL('Table'),'Table'[Sum]),SUMX(ALL('Table'),'Table'[Count]))

 

[Analitika]

IFERROR(VALUE(MAX('Table (2)'[%])),1)=1&&MAX('Table (2)'[%])="textVal1", 

is to complex as i have a lot of values to set manually, and need something like:

SWITCH(

SELECTEDVALUE('Table (2)'[%]),

"textVal1", Value([measureSome%]),

"textVal2", 0.06%,

VALUE('Table (2)'[%])

)

[AiolosZhao]

Hi @Analitika ,

What's the measure1 and measure2?

Please show me your desired result in a screenshot or in a table.

Thanks.

Aiolos Zhao

[Analitika]

It does not matter what is measure1 and measure2, say this is 10 - 5

I cant post anything more as i dont have working measure