Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Combined SWITCH and SELECTEDVALUE function not working for sum of multiple measures

Hi all,   I'm trying to set up a DAX-based table visual for a financial statement - based on financial transactions. My current set up is now based on a YouTube guide (https://www.youtube.com/wa...
financial report
SELECTEDVALUE
Switch()
  • tamerj1's avatar
    tamerj1
    3 years ago

    Anonymous 
    Yes that is a possibility. The engine optimizer might return a blank value and ignores the evaluation of other measures if they came along with a measure that evaluates to a blank.

     

    However, it is worth asking whether you have checked if PowerBi has automatically created a relationship between 'Report Structure'[Line_item_ID] and 'Account mapping'[GLA_Line_item_ID] without you noticing that. That is also a possibility.

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous 
Yes that is a possibility. The engine optimizer might return a blank value and ignores the evaluation of other measures if they came along with a measure that evaluates to a blank.

 

However, it is worth asking whether you have checked if PowerBi has automatically created a relationship between 'Report Structure'[Line_item_ID] and 'Account mapping'[GLA_Line_item_ID] without you noticing that. That is also a possibility.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

tamerj1 you were absolutely right. Deleting the relation fixed it instantly! My boss will be very pleased.

Thanks a lot.

 

Actually I created the relationship myself in an earlier rendition.

Could you please explain why the relationship caused the error?

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Anonymous 
    It is similar to slicing by 'Account mapping'[GLA_Line_item_ID] then using a SWITCH statement on top of it. For sure you'll have EMPTY filter intersections. For example the measure that filters 'Account mapping'[GLA_Line_item_ID] = "Revenue" will have a blank value when the line item is not "Revenue" and so on.