Forum Discussion

Helper I

8 years ago

Solved

what if

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 -...

Need Help

Zubair_Muhammad
8 years ago
madji

Please see attached file

Both artilce 1 and 4 change with selection of a parameter
test(1).pbix35 KB

Zubair_Muhammad

Community Champion

8 years ago

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

Helper I

8 years ago

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