Forum Discussion
Solved
IF statement in a Matrix
Hi all, I have the following Matrix visual as shown down below. Is it possible to tweak the "W/O Reason" measure to get a text line called "Various reasons" in the row "SR_Service_RecID" (11882) in ...
W/O Reason = var r = countrows(values(xxx[No_bill_reason_3])) return switch(true(),r=1,max(xxx[No_bill_reason_3]),r>1,"Various reasons",BLANK())
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
lbendlin Hi, here is a sample data file. I appreciate it if you can help me.
https://www.dropbox.com/s/m02gi8921l97o5z/Sample_Data.pbix?dl=0
