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.
Following DAX expression works with imported data but not with direct query:
[SourceABCKey] IN SELECTCOLUMNS(FILTER('XYZUserDataAccess', 'XYZUserDataAccess'[UserName]=UserName()),
"Sourcekey"
,[ParameterCode])
There are 3 tables:
Table1 - XYZUserDataAccess - This contains username and Parameter, say SalesDistrict or School.
Table2 - DimParameter, say DimSalesDistrict or DimSchool.
Table3 - FactTable with SalesCount or StudentCount and Parameter - SalesDistrict or School.
Relationship exists between Table2 to Table1, and Table2 to Table3.
Tha above DAX expression works on Table2 in imported mode.
In direct query mode it gives error. Tried various expressions on all 3 tables on various scenarios, but non worked.
Hi @Anonymous
Not all DAXformulas works with direct query mode, theer are some limitation because the way those formulas are evaluated .
Givea try to the below opion:
Thanks
Raj
Thank you for reply. I will try it out.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |