Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Difference between column criteria base on calculated table

Hi all,   I created a calculuated table from my data model with the following syntax:   Test Table = SUMMARIZECOLUMNS (OrderIntakeTable[Time_stamp], OrderIntakeTable[Season], "Total Ordered",SUM(...
General Comment
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Dale,

 

The dax work, but it's not the desired output.

 

My data is repeated on rows instead of column.

 

 

When displayed on matrix visual, it did not give the correct calculation.

 

Regards

Hidayat

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Hidayat,

 

This one isn't the one in your first post. Is this one still a calculated table? Can you share the file? Mask the sensitive data first.

 

Best Regards,

Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Dale,

     

    Sorry about that, could have better phrase it on the original post.

    Yes, it is still a calculated table.

     

    Below link to file for reference.

     

    File Link

     

    Best Regards,

    Hidayat

     

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi Hidayat,

       

      Try this one please. 

      Difference 2 =
VAR currentTimeStamp = [Time_stamp]
VAR lastTimeStamp =
    CALCULATE (
        MAX ( 'Test Table'[Time_stamp] ),
        FILTER ( 'Test Table', 'Test Table'[Time_stamp] < currentTimeStamp )
    )
RETURN
    IF (
        ISBLANK ( lastTimeStamp ),
        0,
        CALCULATE (
            SUM ( [Total Ordered] ),
            ALLEXCEPT ( 'Test Table', 'Test Table'[Time_stamp] )
        )
            - CALCULATE (
                SUM ( 'Test Table'[Total Ordered] ),
                FILTER ( 'Test Table', 'Test Table'[Time_stamp] = lastTimeStamp )
            )
    )

       

      Best Regards,

      Dale

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi Dale,

         

        The output is still not correctly calculating.

         

        Regards

        Hidayat