Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hi
i know that's a known issue that new measure cannot be used as a filter
i saw an idea to create a new column with the dax function but apperantly in directQuery i can't use all the functions
this is my measure: new measure=if(CONTAINS('Query1 (2)','Query1 (2)'[combination1],[Measure 3]),1,0)
measure 3 is changing regard the slicers selected, and this measure supposed to give me true or false
i want that the filter will be whthere this measure=1
is anyone have an idea?? hopeless
thanks!
In this scenario, the value in CONTAINS function must be a single scalar value and it only be evaluated once. So you can't put a measure as argument in CONTAINS function since it's dynamic. And the measure will evaluate current row context, but the CONTAINS() function is based on entire table context. I don't think your logic can be achieved.
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
79 | |
65 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |