Forum Discussion

chahine1986's avatar
chahine1986
Frequent Visitor
4 years ago

addcolumns

Hello I am using addcolumns, so when i added a new column with a measure, its not taking filter context   what i did first i created a table of customers using intersect & summarize, then from sal...
Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

I am not sure how your data model looks like, but please try the below DAX formula to create a new table.

 

Week45 returning customers table =
CALCULATETABLE (
    ADDCOLUMNS (
        VALUES ( 'week45 customers'[Customer ID] ),
        "rev", [customer sales]
    ),
    TREATAS (
        SUMMARIZE (
            INTERSECT ( 'week45 customers', 'week45 customers' ),
            'week45 customers'[Customer ID]
        ),
        'week45 customers'[Customer ID]
    )
)
chahine1986's avatar
chahine1986
Frequent Visitor
4 years ago

hi Thanks

 

But my concern is why its giving same value, as am putting in addcolumns measure, when there is measure there should be filter context to my understanding

 

I modified the tables slightly, but still its not working , is there a way that i can share my pbix file?

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    4 years ago

    Hi,

    Thank you for your feedback.

    - Is my measure providing a correct result as you expected?

    - You can share your onedrive's link or dropbox link or google drive link here in order to share your pbix file.

    Thank you.