mkavcic
4 years agoFrequent Visitor
Status:
Investigating
Field Paramters and DAX function Columnstatistics()
Hi, When working with the new feature 'Field Parameters' then DAX function Columnstatics() is not working. It produces composite key error.
mkavcic
4 years agoFrequent Visitor
Hi,
Thank you for your answer Yingjie Li.
Here are more details regarding the error.
I was using COLUMNSTATISTICS function to create a virtual table in DAX Studio.
When using COLUMNSTATISTICS function with the new field parameters table applied, I get a composite key error.
However, I can work with field parameters table in DAX Studio, if I specify the columns correctly. I get the columns and fields accordingly.
Then I tried using COLUMNSTATISTICS function on a data model, that does not have field parameters applied, then it works without an error.
All the best,
Mitja