topic Re: Need Dax Measure in Developer

Need Dax Measure

Prakash1050 — Mon, 19 Jun 2023 11:39:55 GMT

Hi All,

I have 3 tables "a", "b" and "c". The "a", "b" table have one common column and "b", "c" table have one common column. If in the filter pane i selected one value of common column in "a" table should be filter in "c" table. But I don't want to create a relationship between these tables only Measure can be done this scenario. Please help me.

Thanks in Advance.

Re: Need Dax Measure

Anonymous — Wed, 21 Jun 2023 02:00:40 GMT

Hi @Prakash1050,

It seems like you want to achieve two step filter effect without real relationship mappings, you can take a look at me following measure formula if it helps:

formula = VAR list = CALCULATE ( SUM ( TableB[Column2] ), FILTER ( ALLSELECTED ( TableB ), TableB[Column1] IN VALUES ( TableA[Column1] ) ) ) RETURN CALCULATE ( SUM ( TableC[Value] ), FILTER ( ALLSELECTED ( TableC ), TableC[Column2] IN list ) )

Regards,

Xiaoxin Sheng

Re: Need Dax Measure

Prakash1050 — Wed, 21 Jun 2023 04:42:04 GMT

Hi @Anonymous ,
This measure is not correct i clearly mention in the below kindly help me.

I need DAX Measure for not creating relationship and get the answer.

I have 3 Tables A, B, C.

A table have BU, Composite and Key columns.

B table have Key, Entity ID and Fam ID.

C table have Entity ID and Value.

A table key column and B table key column are common column.

B table Entity ID column and C table Entity ID column are common column.

I need DAX for in the filter pane if A table key column selected the B table key column also filterd as well as B table key column direct to the B Table Entity ID Column also filtered and the same Enitity ID in C table column also filterd and get the Value Column answer.

I hope this scenario you understand please help me to acheive this DAX.

Re: Need Dax Measure

Anonymous — Thu, 22 Jun 2023 08:22:35 GMT

Hi @Prakash1050,

It seems like I shared the wrong formulas, you can take a look at the following formulas that I fixed the wrong part and modify with the field name that you shared to get calculation result from Dax condition filters without really relationship mappings.

formula = VAR idList = CALCULATETABLE ( VALUES ( TableB[Entity ID] ), FILTER ( ALLSELECTED ( TableB ), TableB[Key] IN VALUES ( TableA[Key] ) ) ) RETURN CALCULATE ( SUM ( TableC[Value] ), FILTER ( ALLSELECTED ( TableC ), TableC[Entity ID] IN idList ) )

Regards,

Xiaoxin Sheng

Re: Need Dax Measure

Prakash1050 — Thu, 22 Jun 2023 10:08:30 GMT

Hi @Anonymous
Thank you so much this measure is working correctly.