what if

[madji]

HI

I try to use parameters in my example.

Id like to create paramerer only for article1.

after chenging article1  - article4 have to chenge also

my example:

example

if parametr is  2 -

article1 will be 2*100 = 200

and

article4 = article1+article2-article3 = 200+100 - 10

Thanks!

[Zubair_Muhammad]

@madji

Try this MEASURE

Measure =
VAR A1 =
    CALCULATE ( SUM ( 'Таблица1'[Amount] ), 'Таблица1'[Article] = "article1" )
        * [article1]
VAR A2 =
    CALCULATE ( SUM ( 'Таблица1'[Amount] ), 'Таблица1'[Article] = "article2" )
VAR A3 =
    CALCULATE ( SUM ( 'Таблица1'[Amount] ), 'Таблица1'[Article] = "article3" )
RETURN
    SWITCH (
        TRUE (),
        SELECTEDVALUE ( 'Таблица1'[Article] ) = "article4", A1 + A2
            - A3,
        SELECTEDVALUE ( 'Таблица1'[Article] ) = "article1", A1,
        SUM ( 'Таблица1'[Amount] )
    )

[Zubair_Muhammad · Accepted solution]

@madji

Please see attached file

Both artilce 1 and 4 change with selection of a parameter

[Zubair_Muhammad]

HI @madji

Try this MEASURE

Measure =
VAR A1 =
    CALCULATE ( SUM ( 'Таблица1'[Amount] ), 'Таблица1'[Article] = "article1" )
        * [article1]
VAR A2 =
    CALCULATE ( SUM ( 'Таблица1'[Amount] ), 'Таблица1'[Article] = "article2" )
VAR A3 =
    CALCULATE ( SUM ( 'Таблица1'[Amount] ), 'Таблица1'[Article] = "article3" )
RETURN
    SWITCH (
        TRUE (),
        SELECTEDVALUE ( 'Таблица1'[Article] ) = "article4", A1 + A2
            - A3,
        SELECTEDVALUE ( 'Таблица1'[Article] ) = "article1", A1,
        SUM ( 'Таблица1'[Amount] )
    )

[Zubair_Muhammad]

Hi @madji

You can use this MEASURE

Measure =
VAR A1 =
    CALCULATE ( SUM ( 'Таблица1'[Amount] ), 'Таблица1'[Article] = "article1" )
        * [article1]
VAR A2 =
    CALCULATE ( SUM ( 'Таблица1'[Amount] ), 'Таблица1'[Article] = "article2" )
VAR A3 =
    CALCULATE ( SUM ( 'Таблица1'[Amount] ), 'Таблица1'[Article] = "article3" )
RETURN
    SWITCH (
        TRUE (),
        SELECTEDVALUE ( 'Таблица1'[Article] ) = "article4", A1 + A2
            - A3,
        SELECTEDVALUE ( 'Таблица1'[Article] ) = "article1", A1,
        SUM ( 'Таблица1'[Amount] )
    )

[madji]

That is right, but I have use paprametr for article 1 too

for example,  I want to chenge article 1 throught parametr

after this my article4 have to be chenge also

	Sum	value1
Article1	100	105
Article2	100	100
Article3	10	10
Article4	190	195