Forum Discussion
Filter a virtual table
Hello everyone, How can I filter a virtual table dynamically? I need the "u_country" column to change according to the user's choice. Summarize_Table = CALCULATETABLE( ...
Do you mean:
Summarize_Table =
SUMMARIZE(
FILTER('SQL - Problem'[u_country] = "Chile");
'SQL - Problem'[_Index];
"Total_Lines"; COUNT('SQL - Problem'[Number]);
"Total_Group"; SUM('SQL - Problem'[_Duration-Days(All)]);
"Average"; AVERAGE('SQL - Problem'[_Duration-Days(All)]);
"Stdev"; STDEV.P('SQL - Problem'[_Duration-Days(All)]);
"Date_Period"; MIN('SQL - Problem'[Created].[Date]) & " - " & MAX('SQL - Problem'[Created].[Date])
);
Not exactly, the calculations would be performed for the country that the user chooses.
The country is not fixed.