Forum Discussion

rmbuchan's avatar
rmbuchan
Frequent Visitor
3 years ago
Solved

How to stop the Switch Function from replacing a calculated value with a null value

Hello All,    I could use help with the Switch ( TRUE () function.    If I use a calculated value the switch result is null   However, if I hardcode a number in the switch instead of the ...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    3 years ago

    Hi rmbuchan 

     

    Your [PL Actuals] measure is told to return the value of [Income] when the row index is 3.  

     

    [Income] calculates [PL Values] when the Category is Income.  This is the problem.  The Category for rows with row index 3 is Total Income.  That's why you're getting a blank here.

     

    You can fix the issue by modifying this line in the SWITCH to 

     

     

    CRSindex = 3, CALCULATE([PL Values], 'RPT Income Statement'[Category] = "Total Income"),

     

     

     

    Regards

     

    Phil

     

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
3 years ago

Hi rmbuchan 

 

It may very well produce values when charted but it's how the value is calculated when it's in the matrix that is the issue.

 

I presume [PL Values] is a measure?  How is that calculated?

 

Can you provide your file?  It woudl be easier to check if I have that.

 

Regards

 

Phil 

  • rmbuchan's avatar
    rmbuchan
    Frequent Visitor
    3 years ago

    Philip, 

     

    Yes, PL Values is a measure. Here is the calculation: 

     

    PL Values =
    SUM( 'RPT Income Statement'[Act Amt])
     
    The pbix file is a bit of mess right now because I've tried doing a lot of things to figure this issue out, but I can upload it if this calculation doesn't help.