Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Adding a MEASURE to a TABLE

Looking for assistance!   We are trying to use the difference between; TestID 2, V1 and TestID 1 V1 in Table1, as the Z value for V1 in Table2.   In Table1 I have some data from a test.  W...
Need Help
  • TeigeGao's avatar
    TeigeGao
    7 years ago

    Hi Anonymous ,

    According to your description, my understanding is that you are going to put the difference of V1 (Last one - Top one) to the set V1-Z.

    Assume that we have the following two tables:

    Then we can create a measure like below:

    Z =
IF (
    MIN ( Table2[VAR] ) = "V1",
    CALCULATE ( MIN ( Table1[V1] ), TOPN ( 1, Table1, Table1[TestID], DESC ) )
        - CALCULATE ( MIN ( Table1[V1] ), TOPN ( 1, Table1, Table1[TestID], ASC ) ),
    CALCULATE ( MIN ( Table1[V2] ), TOPN ( 1, Table1, Table1[TestID], DESC ) )
        - CALCULATE ( MIN ( Table1[V2] ), TOPN ( 1, Table1, Table1[TestID], ASC ) )
)

    The result will like below:

    Best Regards,

    Teige

TeigeGao's avatar
TeigeGao
Solution Sage
7 years ago

Hi Anonymous ,

According to your description, my understanding is that you are going to put the difference of V1 (Last one - Top one) to the set V1-Z.

Assume that we have the following two tables:

Then we can create a measure like below:

Z =
IF (
    MIN ( Table2[VAR] ) = "V1",
    CALCULATE ( MIN ( Table1[V1] ), TOPN ( 1, Table1, Table1[TestID], DESC ) )
        - CALCULATE ( MIN ( Table1[V1] ), TOPN ( 1, Table1, Table1[TestID], ASC ) ),
    CALCULATE ( MIN ( Table1[V2] ), TOPN ( 1, Table1, Table1[TestID], DESC ) )
        - CALCULATE ( MIN ( Table1[V2] ), TOPN ( 1, Table1, Table1[TestID], ASC ) )
)

The result will like below:

Best Regards,

Teige

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    TeigeGao 

    Thanks, this worked great!