Forum Discussion

madji's avatar
madji
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's avatar
Zubair_Muhammad
Community Champion
8 years ago

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] )
    )