Forum Discussion
If function
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