Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have created a disconnected table with multiple values along with a DAX measure to refer to different measures in my fact table.
Solved! Go to Solution.
Hi,
I am not sure if I understood your question correctly, but please try something like below.
ACCVALUE =
SUMX (
VALUES ( ACCOUNTS[ACCOUNT_NAME] ),
SWITCH (
TRUE (),
CALCULATE ( SELECTEDVALUE ( ACCOUNTS[ACCOUNT_NAME] ) ) = "Actuals", [Actuals],
CALCULATE ( SELECTEDVALUE ( ACCOUNTS[ACCOUNT_NAME] ) ) = "BL", [BL],
CALCULATE ( SELECTEDVALUE ( ACCOUNTS[ACCOUNT_NAME] ) ) = "SS", [SS],
CALCULATE ( SELECTEDVALUE ( ACCOUNTS[ACCOUNT_NAME] ) ) = "Deductions", [Deductions]
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I am not sure if I understood your question correctly, but please try something like below.
ACCVALUE =
SUMX (
VALUES ( ACCOUNTS[ACCOUNT_NAME] ),
SWITCH (
TRUE (),
CALCULATE ( SELECTEDVALUE ( ACCOUNTS[ACCOUNT_NAME] ) ) = "Actuals", [Actuals],
CALCULATE ( SELECTEDVALUE ( ACCOUNTS[ACCOUNT_NAME] ) ) = "BL", [BL],
CALCULATE ( SELECTEDVALUE ( ACCOUNTS[ACCOUNT_NAME] ) ) = "SS", [SS],
CALCULATE ( SELECTEDVALUE ( ACCOUNTS[ACCOUNT_NAME] ) ) = "Deductions", [Deductions]
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi @Jihwan_Kim, yes that's exactly what I needed. I couldn't figure out how to do the logic using SUMX and SELECTEDVALUE. Thanks a lot.