Return a Value

[Anonymous]

Hello everyone

I would like to return a value from a column that is the result of an IF,

the value I want to return is a column when the value meets some condition: IF(Table1[value] >= "98", Table1[value2]), I can not use a mesure for the sintaxis of the IF

I can got the value that I need, but when I put on the table I need to display the information, It repeats the same value for all the columns.

There is a way to fix that?

Note: all the values on the table are not the same, that is why I don't know how to diplay the correct value.

[Anonymous · Accepted solution]

Hi @Anand24 

The example could be something like this, there is another data but for the calculation I need, is based on this two fields, as you can see, it returns only one value, but in the data, there is 3 values that are "true" based on the expresion:

Column = IF(Table1[value] >= "98%", Table1[value2])

Value1	Value2	Result
50%	BD1	BD5
45%	BD2	BD5
98%	BD3	BD5
99%	BD4	BD5
100%	BD5	BD5

On the table chart, it appears as Fist of Column, maybe that could be the error, there is a way to change that too?

Best Regards and thanks for your help

[Anand24 · Accepted solution]

@Anonymous ,
I'm able to understand your query very vageuly but Try creating a calculated measure with the same formula.
Also, what should be shown for false cases? In your example, for 50% and 45%.

Try the below DAX as well:
Conditional Measure = IF(Table[Value1] >= 0.98,Table[Value2],BLANK())

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[v-luwang-msft]

Hi @Anonymous ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft · Accepted solution]

Hi @Anonymous ,

Base data:

Column = IF('Table'[Value1]>= 0.98, 'Table'[Value2])

The result output is correct.And Check your value1 type,if question still not solved ,could you pls share your pbix flie?

And remember to remove confidential data.

Best Regards

Lucien

[Anonymous · Accepted solution]

Hi @Anand24 

The example could be something like this, there is another data but for the calculation I need, is based on this two fields, as you can see, it returns only one value, but in the data, there is 3 values that are "true" based on the expresion:

Column = IF(Table1[value] >= "98%", Table1[value2])

Value1	Value2	Result
50%	BD1	BD5
45%	BD2	BD5
98%	BD3	BD5
99%	BD4	BD5
100%	BD5	BD5

On the table chart, it appears as Fist of Column, maybe that could be the error, there is a way to change that too?

Best Regards and thanks for your help

[Anand24 · Accepted solution]

@Anonymous ,
I'm able to understand your query very vageuly but Try creating a calculated measure with the same formula.
Also, what should be shown for false cases? In your example, for 50% and 45%.

Try the below DAX as well:
Conditional Measure = IF(Table[Value1] >= 0.98,Table[Value2],BLANK())

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[Anand24]

Hi @Anonymous ,
Can you provide some sample data and expected output? Both in Tabular format.
Also, are both value1 and value2 coming from the same table?

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn