Forum Discussion
If statement doesn't allow to select columns
Hello guys,
I hope you are well.
I have a very simple problem but I wasn't able to fix it.
Indeed, I would like to create a IF statement like this = IF (And([QT received]=0,[Status]="closed"),0,1).
But DAX doesn't allow me to select a column in the parameters but only measures.
Do you know why ?
Many thanks for your help
Hi Anonymous,
What the 'blank' means? 'blank' text or null value? If you mean the null value, you can use camargos88 's suggestion. For 'blank' text, you need to change the conditions to compare with 'blank'.
Measure = VAR qtReceiver = SELECTEDVALUE ( 'Table'[QT received] ) VAR _status = SELECTEDVALUE ( 'Table'[Status] ) RETURN IF ( qtReceiver = "blank" && _status = "Closed", 1, 0 )BTW, the above formula not suitable to use to compare with summarize row contents. For this scenario, you can try to use the following measure formula:
Measure = VAR summary = SUMMARIZE ( Table, [Name], [QT Receive], [Status], "If statement", IF ( [QT Receive] = "Blank" && _status = "Closed", 1, 0 ) ) RETURN CONCATENATEX ( summary, [If statement], "," )Regards,
Xiaoxin Sheng
6 Replies
Within a measure, you need to wrap a column reference in an aggregator like SUM, COUNT, MAX, MIN, AVERAGE, etc.
Thank you for you quick ansawer Greg_Deckler !
I see but in my case, I don't know how to aggregate.
Indeed I have the data below and I would like to measure IF QT received is Blank and Status closed then 0 otherwise 1.
Name QT received Status If statement X blank Closed 0 Y 1 Open 1 Z 0 Open 1 camargos88 's formula should work. I generally just use MAX instead of SELECTEDVALUE but same kind of thing.
