Forum Discussion
Solved
Need help with measure
I have got tables through between which I need to create a measure to get the desired results. Conditional Logic: The IF statement checks if: Table 1 Customer equals Table 2 Customer Table 1...
Hi,
Please check the below picture and the attached pbix file.
Thank you.
Expected result measure = VAR _customerselect = SELECTEDVALUE('Table 2'[Customer]) VAR _statusselect = SELECTEDVALUE('Table 2'[Status]) VAR _type = SUMMARIZE ( FILTER ( 'Table 1', 'Table 1'[Customer] = _customerselect && 'Table 1'[Tool] = "Yes" ), 'Table 1'[Type] ) VAR _condition = _statusselect = "Online" RETURN IF ( _condition, _type )
Hi Jihwan_Kim - The result you obtained is what I need. Instead of a calculated column, can I achieve this through a measure?
Hi,
Please check the below picture and the attached pbix file.
Thank you.
Expected result measure =
VAR _customerselect = SELECTEDVALUE('Table 2'[Customer])
VAR _statusselect = SELECTEDVALUE('Table 2'[Status])
VAR _type =
SUMMARIZE (
FILTER (
'Table 1',
'Table 1'[Customer] = _customerselect
&& 'Table 1'[Tool] = "Yes"
),
'Table 1'[Type]
)
VAR _condition = _statusselect = "Online"
RETURN
IF ( _condition, _type )