topic Re: Calendar table to filter 2 tables that have existing Relationship aka Lapse New Trading in DAX Commands and Tips

Calendar table to filter 2 tables that have existing Relationship aka Lapse New Trading

Anonymous — Thu, 06 Mar 2025 05:29:47 GMT

I have 3 tables that has ambiguous relations - where the date table filters 2 table.

At the same time the Status Table needs to filter Fact Sales.

My attemtp to overcome this, I wrote the following DAX but did not work

Total Sales = Calculate(sum(SALES),

TREATEAS(SUMMARIZE(Fact Sales [CUSTOMER]),Status Table [CUSTOMER]))

The desired outcome is in Image below. thank you in advanced

Re: Calendar table to filter 2 tables that have existing Relationship aka Lapse New Trading

Dangar332 — Thu, 06 Mar 2025 05:58:03 GMT

Hi, Anonymous

Try below measure

Total Sales = Calculate( sum('fact sales'[SALES]), TREATEAS(all(Status Table [CUSTOMER]),Fact Sales [CUSTOMER]))

If still does not work then please provide Screenshot of your data model

Best Regards,
Dangar

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Calendar table to filter 2 tables that have existing Relationship aka Lapse New Trading

mdaatifraza5556 — Thu, 06 Mar 2025 06:11:29 GMT

Hi Anonymous
Remove the relationship between fact and status and in the fact table bring the status column using LOOKUPVALUE.
checkout the below DAX

status = LOOKUPVALUE('Status Table'[Status], 'Status Table'[MTH], 'Fact Sales'[MTH], 'Status Table'[Cust], 'Fact Sales'[Cust])

Drag the column from the calendar and the fact.

Re: Calendar table to filter 2 tables that have existing Relationship aka Lapse New Trading

mdaatifraza5556 — Thu, 06 Mar 2025 06:24:19 GMT

Hi Anonymous

You can use my first approach which is using LOOKUPVALUE DAX.
OR
correct your DAXusing below DAX.

saless =

CALCULATE(

SUM('Fact Sales'[Sales]),

TREATAS(VALUES('Fact Sales'[Cust]), 'Status Table'[Cust]))

Re: Calendar table to filter 2 tables that have existing Relationship aka Lapse New Trading

v-menakakota — Wed, 09 Apr 2025 04:46:01 GMT

Hi Anonymous ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Re: Calendar table to filter 2 tables that have existing Relationship aka Lapse New Trading

v-menakakota — Fri, 02 May 2025 10:01:04 GMT

Hi @Eisha ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

Re: Calendar table to filter 2 tables that have existing Relationship aka Lapse New Trading

v-menakakota — Mon, 05 May 2025 06:46:50 GMT

Hi Anonymous ,

I hope the provided information by mdaatifraza5556 is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you