SelectedValue works with text results, not with numeric results

[AdinRivera]

Hi PBI experts,

I am trying to create a measure using selectedvalue with two conditions, the case is, when I set it to display text whe both result false or true, it works fine, however, when I use the calculate function to get a value, it doesn't display any value:

It works:

Test3 =

IF (

    SELECTEDVALUE ( Category[Category] ) = "Volume"

        && SELECTEDVALUE ( Selection[Selection] ) = "PC",

    "Volume (PC)",

    IF (

        SELECTEDVALUE ( Category[Category] ) = "Volume"

            && SELECTEDVALUE ( Selection[Selection] ) = "9L",

        "Volume (9L)",

        [Actual]

    )

)

This way is not working:

Test =

IF (

    SELECTEDVALUE ( Category[Category] ) = "Volume"

        && SELECTEDVALUE ( Selection[Selection] ) = "PC",

    CALCULATE ( SUM ( Data[Values] ), 'Data'[Category] = "Volume (PC)" ),

    IF (

        SELECTEDVALUE ( Category[Category] ) = "Volume"

            && SELECTEDVALUE ( Selection[Selection] ) = "9L",

        CALCULATE ( SUM ( Data[Values] ), 'Data'[Category] = "Volume (9L)" ),

        [Actual]

    )

)

In this case, I would expect that when I select the PC option in the slicer, the Volume row will show the value of the Volume (PC) row ( 148,284) and when you select the 9L option, it will show the value of the Volume (9L) row (119). Currently, it shows 0.

I've attached the PBIX file for more information:

PBIX File 

Could somebody help me, please? 

Thanks.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[AdinRivera]

Hi lbendlin, thank you for your advice. I've just added the PBIX file and the expected result. I hope you can help me.

Regards.