It then uses the KEEPFILTERS function to preserve any filters applied to the visual. This measure uses the FILTER function to filter the rows in the "X_DETAIL" table based on the selected "id" and "B" values from the "Y_SUMMARY" table. "email_count", CALCULATE(COUNT(DISTINCT 'X_DETAIL')) 'X_DETAIL' = SELECTEDVALUE('Y_SUMMARY') & You can then create a DirectQuery measure in Power BI that uses this SQL query directly. One approach is to use the GROUP BY clause in SQL directly to group the rows by the "a" column and then use COUNT(DISTINCT email_id) to count the distinct values of the "email_id" column. I've also tried various versions of measures as well and I get the same result. (I realize this table probably needs filters on it as well, but even this simple version doesn't work) ,and this gives me "we couldn't fold the expression to the data source" error. SUMMARIZE(X_DETAILS, X_DETAILS, "Email Count", DISTINCTCOUNT(X_DETAILS)) SELECT a, count(distinct email_id) from X_DETAIL where id = 12345 and b = "Email Delivered" group by a So let's say the user selects B= "Email Delivered" and they have also selected ID = 12345 I want to be able to show distinct counts of one column (call that EMAIL_ID) on X_DETAIL and I want this to be filterable and groupable by ID and also columns A and B on X_DETAILS I have a DirectQuery table (call that X_DETAIL), it's linked via a column, let's call that `id` to a summary table (Y_SUMMARY) that I'm using to drive my visualization. I think the following may be an obvious question but I'm continuing to run into the "we couldn't fold the expression to the data source" error.
0 kommentar(er)
