Forum Discussion
Sorting table with multiple columns
Hi All, I need to create a Line and Stacked chart for which multiple columns will be derived using the following conditions: Table name: Survey Steps/Logic: calculate the no. of surveys Group by...
Anonymous solution attached, look at table1 in attached, it has few columns and measures. you can play with it as per your need, didn't had much time to work on it thou but I guess you will get idea from it.
Hi parry2k
Thank you for the reply. I am getting ciurcular dependency :(
Below are the 2 screenshots for your reference.
The table is created using a DAX expression which is as below:
Table =
VAR current_month= [#_LATEST_MONTH]
RETURN
SUMMARIZE(CUSTSURVEY, CUSTSURVEY[ASSIGNEE_SUPPORT_GROUP],
"#_of_Survey",
CALCULATE(COUNT(CUSTSURVEY[ENTRY_ID]), FILTER(CUSTSURVEY, [#_GET_MONTH_AND_YEAR] = current_month && [#_IS_SURVEY_RESPONDED] = "Yes")),
"% Negative Reviews",
(CALCULATE (
COUNT ('CUSTSURVEY'[ENTRY_ID]),
FILTER (
'CUSTSURVEY',
(
'CUSTSURVEY'[#_GET_MONTH_AND_YEAR] = current_month
&& (('CUSTSURVEY'[OVERALL_EXP] = 0)||('CUSTSURVEY'[OVERALL_EXP] = 1))
&& NOT ISBLANK ('CUSTSURVEY'[OVERALL_EXP])
)
)
)
/ CALCULATE (
COUNT ( 'CUSTSURVEY'[ENTRY_ID] ),
FILTER (
'CUSTSURVEY',
( 'CUSTSURVEY'[#_GET_MONTH_AND_YEAR] = current_month
&& ( 'CUSTSURVEY'[#_IS_SURVEY_RESPONDED] = "Yes" ) )
)
)
)
)Can you tell me what am missing? Thanks!
Anonymous when you get chance, can you PM me?