Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
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 )
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
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
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
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
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 )
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |