- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Calculate Column based on another table without relationship
Hi guys,
I'm beginner in Power BI and need help.
I need a DAX column with my customer list that will show their sales in the slicers based on the year and item group selected from the sales data without the use of a relationship.
This is the sample result I'm looking for:
Test File - https://drive.google.com/file/d/10VLWUhmGCSoHUxvK4yeiR77mKlbNMBcA/view?usp=drive_link
Thank you in advance, and I appreciate everyone! 😊
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @elemesey ,
Try this
Sum of Sales2 =
CALCULATE (
SUM ( Sales[Sales] ),
FILTER (
Sales,
Sales[Date]
IN VALUES ( 'Fiscal Year based on Sales'[Date] )
&& Sales[Customer]
IN VALUES ( Allcustomer[Customer] )
&& Sales[Region] IN VALUES ( Allcustomer[Region] )
)
)
You can add or rmove IN filters as needed.
Dane Belarmino | Microsoft MVP | Proud to be a Super User!
Did I answer your question? Mark my post as a solution!
"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @danextian ,
I greatly appreciate your quick help 😊
Unfortunately, it didn't give my desired result; perhaps I did not explain clearly. The DAX formula you provided is the total of all customers, whether filtered or not. . Please see below images for your reference.
No Filter:
With Filter:
What I want is the sales will be reflected based on what year I selected, as well in the item group.
If you could continue to assist me, I would be grateful 🙂
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The formula should be correct. Please make sure you're using the correct columns
Please see attached pbix for your reference.
PS: this would have been simple had you used relationships.
Dane Belarmino | Microsoft MVP | Proud to be a Super User!
Did I answer your question? Mark my post as a solution!
"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you @danextian. Yeah the DAX works now using the sales table 🙂
But is this doable in the Customer Master table? In my main file, I need a DAX that displays the sales scenario for my Customer master. I know relationship can simple do this, however I need a DAX formula because relationship is no longer applicable in my main file.
I would appreciate it if you could continue to assist me 🙂

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
02-16-2024 10:07 AM | |||
Anonymous
| 04-02-2024 06:27 AM | ||
11-08-2023 11:58 AM | |||
11-27-2023 07:37 AM | |||
03-26-2024 02:07 AM |
User | Count |
---|---|
87 | |
81 | |
53 | |
38 | |
35 |