Forum Discussion

SwathiGanesh's avatar
SwathiGanesh
Frequent Visitor
3 years ago

Need syntax help to summarize only the selected column

I have three columns in a table and we are using parameters to select the required column to the table. Based on the selected column, I need to summarize and do some calculation. I am stuck and un...
Need Help
Sahir_Maharaj's avatar
Sahir_Maharaj
Icon for Super User rankSuper User
3 years ago

Hello SwathiGanesh,

 

You can use the SWITCH function to check which column is selected.

 

Uniques =
VAR SelectedColumn = SELECTEDVALUE('Table'[Parameter])
VAR sumfc = SUM('Table'[Salary])
VAR SUMMARISE =
    SWITCH(
        SelectedColumn,
        "Partnername", SUMMARIZE('Table', 'Table'[Partnername], "Average", sumfc),
        "partnerTYPE", SUMMARIZE('Table', 'Table'[partnerTYPE], "Average", sumfc),
        "partnercountry", SUMMARIZE('Table', 'Table'[partnercountry], "Average", sumfc)
    )
RETURN
    IF(
        OR(
            ISINSCOPE('Table'[Partnername]),
            OR(ISINSCOPE('Table'[partnerTYPE]), ISINSCOPE('Table'[partnercountry]))
        ),
        SUM('Table'[Salary]),
        DIVIDE(sumfc, COUNTROWS(SUMMARISE))
    )

 

Should you require further assistance, please do not hesitate to reach out.