Community Center | Not monitored
Tag not monitored by Microsoft.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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:
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]
)