how to write dax formula for selectedvalue for both columns and rows

Powercap 0 Reputation points
2023-06-01T04:43:41.01+00:00

Hi guys ,

Iam facing trouble write creating dax formula,the secenario is simple in rows am having the text datatype and rows too.. based on both rows and columns combination i need to calculate the value

EX:

User's image

I tried using selected value function as below i didnt get the required result, please help to slove the issue

Selected Measure = SWITCH(TRUE(),
                           SELECTEDVALUE('Row Description'[Row Description])="Overall Customers" || SELECTEDVALUE('Column Description'[Column Description])="Cust. Count" ,[Overall Customers Custid],
                           SELECTEDVALUE('Row Description'[Row Description])="Overall Customers" || SELECTEDVALUE('Column Description'[Column Description])="FD Count"  ,[Overall Customers FD],
                            SELECTEDVALUE('Row Description'[Row Description])="Overall Customers" || SELECTEDVALUE('Column Description'[Column Description])="Amount",[Overall Customers Amount],
                             SELECTEDVALUE('Row Description'[Row Description])="Renewals" || SELECTEDVALUE('Column Description'[Column Description])="Cust. Count",[Renewal Cust Count],
                             SELECTEDVALUE('Row Description'[Row Description])="Renewals" || SELECTEDVALUE('Column Description'[Column Description])="FD Count",[Renewal FD Count],
                             SELECTEDVALUE('Row Description'[Row Description])="Renewals" || SELECTEDVALUE('Column Description'[Column Description])="Amount",[Renewal Amount]
                             
)


Community Center | Not monitored
0 comments No comments
{count} votes

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.