topic DAX condition if in DAX Commands and Tips

DAX condition if

Anonymous — Thu, 28 May 2020 10:07:14 GMT

Hello,

I have many tables in power query that I don't want to merge. I'd like thanks to DAX to do somethong like this :

If ('Tab1'[Type] = "Pipe")

then return 'Tab1'[thickness] * Tab2[surface] where 'Tab1'[Size] = 'Tab2'[Size]

else return 'Tab1'[thickness]

Tab1
Type	Size	thickness
Pipe	7	30
Valve	2	20
Pipe	6	20
Valve	5	20

Tab2
Size	new_size
2	4
5	9
6	8
7	1

I don't know how to manage the "where 'Tab1'[Size] = 'Tab2'[Size]" part of it. Any idea ?

Thanks a lot !

Re: DAX condition if

AlB — Thu, 28 May 2020 12:01:09 GMT

Hi Anonymous

Can you provide an example based on the data, with the expected result?

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers

Re: DAX condition if

Anonymous — Thu, 28 May 2020 11:38:43 GMT

Hi,

Thanks for answering me. I have the 2 below tables :

T_Data:

T_size:

I try to do some thing like this : mesure = if('T_Data'[Type] = "Pipe",if('T_Data'[DN] = 'T_size'[DN],SUM('T_Data'[Thickness]) * SUM('T_size'[Surface pipe (m2/ml)]),0),0).

I'd like to have a meusure where I have sum of all pipe thickness by surface : 'T_Data'[Thickness] * 'T_size'[Surface pipe (m2/ml)] where type = pipe for each DN corresponding surface.

Is that clear or do you need more details ?

Thanks !

Re: DAX condition if

Anonymous — Fri, 29 May 2020 05:14:34 GMT

Hi Anonymous ,

Assuming that you have a relationship between Data Table and Size Table.

Using MEASURES

Thickness*Size =

SWITCH(

TRUE(),

MAX(Data[Type]) = "Pipe" && MAX(Data[Size]) = MAX(Size[Size]), MAX(Data[thickness]) * MAx(Size[new_size]),

MAx(Data[thickness])

)

USING A CALCULATED COLUMN

Thickness*Size Column =

SWITCH(

TRUE(),

Data[Type] = "Pipe" && Data[Size] = RELATED(Size[Size]), Data[thickness] * RELATED (Size[new_size]),

Data[thickness]

)

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Re: DAX condition if

Anonymous — Fri, 29 May 2020 09:46:50 GMT

Hi,

Thanks a lot ! the calculated column method works perfectly!

Re: DAX condition if

Anonymous — Fri, 29 May 2020 09:50:10 GMT

Anonymous ,

Hahaha..

Loved the spoiler.

Happy to help.

Regards,

Harsh Nathani

Re: DAX condition if

Anonymous — Fri, 29 May 2020 09:52:07 GMT

Not done on purpose. 😅