Forum Discussion
Returning a value
Hello, How can I write a measure that if the value to be 0 to return it as No Value rather than Blank. Scenario: I have Three tables Request ID, Priority, and Technician. The slicer is alr...
Anonymous I don't know, seems to work. See attached PBIX file below sig, Page 16
amitchandak
Super User
Super UserAnonymous , +0 can help typically
Try like
Assigned_P4 = if(ISFILTERED('Priorities'[Request ID]), FIRSTNONBLANK('Priorities'[Priority],0)+0, 1)