Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 sales table (which is my fact table), i took the measure that i created for total sales (i called it customer sales),
what i want is to use addcolumns for my new customer table to add customer sales , so when am adding the measure of customer sales its giving wrong sum not taking into account filter, as i know if i have a measure it should take filter context
please advise why its behaving like that
note: this is just a trial , am trying to understand dax more , & addcolumns
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]
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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?
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |