cancel
Showing results for
Did you mean:
Highlighted
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

Accepted Solutions
Highlighted
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
Highlighted
Super User I

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!

Highlighted
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

Highlighted
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.
Highlighted
Post Prodigy

measureSome% = TotalCount / TotalSum

and same for each row,

Highlighted
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.
Highlighted
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)'[%])
)

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors