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 -

article1 will be 2*100 = 200

and

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

 

Thanks!

Need Help

5 Replies

  • Zubair_Muhammad's avatar
    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's avatar
      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

       

        Sumvalue1
      Article1100105
      Article2100100
      Article31010
      Article4190195
  • 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] )
    )
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

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