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

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