cancel
Showing results for
Did you mean: Post Prodigy

## Fixed percentage number from related table

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 ?

1 ACCEPTED SOLUTION Community Support

this one?

``measureSome% = DIVIDE(SUMX(ALL('Table'),'Table'[Sum]),SUMX(ALL('Table'),'Table'[Count]))`` Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
6 REPLIES 6 Community Support

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.

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly. Post Prodigy

measureSome% = TotalCount / TotalSum

and same for each row,  Community Support

this one?

``measureSome% = DIVIDE(SUMX(ALL('Table'),'Table'[Sum]),SUMX(ALL('Table'),'Table'[Count]))`` Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly. Post Prodigy
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)'[%])
) Memorable Member

Hi @Analitika ,

What's the measure1 and measure2?

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

Thanks.

Aiolos Zhao

Proud to be a Super User! Post Prodigy

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   