Forum Discussion

vandam2's avatar
vandam2
Frequent Visitor
2 years ago
Solved

Report edit with 'If' Statements

Hello Gang, not sure how to even ask this question, but i would like a way to filter and to add formatting to this report

 

i have two status's, Nuance_Status and PACS.Status

 

i would like to filter out any rows where Nuance_Status = Complete and PACS.Status = New,

 

if Nuance_Status = Complete and PACS.Status = blank, then keep on report but replace blank text with 'No Images'

 

not sure if i have to do something i powerquery, or if i can use a measure in PowerBI

hope this isnt too confusing, 

thank you in advance 

 

 

Need Help
  • j_ocean's avatar
    j_ocean
    2 years ago

    Since both columns are in the same table I'd suggest PQ over a measure. Just add a logical column to determine an overall satus based on the possible combinations of the two other statuses. Then filter on that. 

     

    A measure would be more like if you have the info in two different places and need a view that dynamically determines it live based on the other filters currently applied. It also can be a pain to filter by because it needs a visual context to evaluate, so can't be in a report slicer or page level filter.

2 Replies

  • j_ocean's avatar
    j_ocean
    Helper V
    2 years ago

    Since both columns are in the same table I'd suggest PQ over a measure. Just add a logical column to determine an overall satus based on the possible combinations of the two other statuses. Then filter on that. 

     

    A measure would be more like if you have the info in two different places and need a view that dynamically determines it live based on the other filters currently applied. It also can be a pain to filter by because it needs a visual context to evaluate, so can't be in a report slicer or page level filter.