topic Re: If function in DAX Commands and Tips

If function

Kjaer — Sun, 14 Nov 2021 18:27:57 GMT

I have a table like this

I want to make a new measure

But it doesn´t work. I get this error-message:

A single value for the 'item' column in the 'test' table cannot be determined. This can happen when a measurement formula refers to a column that contains many values without specifying an aggregation function such as min, max, count or sum to form a single result.

Can anyone help me?

Re: If function

AlexisOlson — Sun, 14 Nov 2021 19:06:40 GMT

This code should work if you are writing a calculated column that has the row context to make sense of it.

However, for a measure, it doesn't automatically know which row you're referring to when you write "test[item]", so you need to use an aggregation like MAX or SELECTEDVALUE like this:

IF ( SELECTEDVALUE ( test[item] ) = "A", 1, 0 )

Re: If function

Kjaer — Sun, 14 Nov 2021 20:05:11 GMT

Thanks, it works 😊

But then two more questions:

1. How do I write the aggregation, if I want 1 (one) if test[item] = A or if test[item] = B or if test[item] =C

2. Can the aggregation be written so if the condition is fullfilled (i.e. 1) the font shall change to Serge UI Bold

Re: If function

Kjaer — Mon, 15 Nov 2021 19:43:56 GMT

AlexisOlson

Two more questions:

1. How do I write the aggregation, if I want 1 (one) if test[item] = A or if test[item] = B or if test[item] =C

2. Can the aggregation be written so if the condition is fullfilled (i.e. 1) the font shall change to Serge UI Bold

Thanks in advance

Re: If function

AlexisOlson — Mon, 15 Nov 2021 19:54:19 GMT

1. I'd probably write that like this:

IF ( SELECTEDVALUE ( test[item] ) IN { "A", "B", "C" }, 1, 0 )

2. Font face cannot be conditionally formatted like font color and background color can be. Not yet anyway.

You may want to vote and comment on related ideas like this one:
https://ideas.powerbi.com/ideas/idea/?ideaid=29c97607-0484-4f4a-821a-d1a43ff9fc41