Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello,
I am looking to use the INFO.VIEW.MEASURES() within a calculated table.
When I run the command via DAX Query View there is no issue.
However, when I use it within a calculated table the datatypes are all shown as Blank.
Is this a known issue/limitaion or does anyone know of a fix?
Datatypes in DAX Query View using INFO.VIEW.MEASURES()
Datatypes in Calculated Table using INFO.VIEW.MEASURES()
Thank you!
Solved! Go to Solution.
Hi @Tors - Yes, this is a known limitation when using INFO.VIEW.MEASURES() inside a calculated table in Power BI.
Use INFO.VIEW.MEASURES() in DAX Query View for Debugging
If your goal is to inspect measures and their datatypes, running the query separately in DAX Query View is the best option.
Store the Output in an External Table
Instead of using it in a calculated table, consider exporting the output from DAX Query View and loading it as a separate dataset.
Manually Assign Data Types
If you still want to use it in a calculated table, create a new column to manually assign datatypes based on measure names.
Hope this works.
Proud to be a Super User! | |
Hi @Tors - Yes, this is a known limitation when using INFO.VIEW.MEASURES() inside a calculated table in Power BI.
Use INFO.VIEW.MEASURES() in DAX Query View for Debugging
If your goal is to inspect measures and their datatypes, running the query separately in DAX Query View is the best option.
Store the Output in an External Table
Instead of using it in a calculated table, consider exporting the output from DAX Query View and loading it as a separate dataset.
Manually Assign Data Types
If you still want to use it in a calculated table, create a new column to manually assign datatypes based on measure names.
Hope this works.
Proud to be a Super User! | |
Thank you for your help.
Do you happen to know if its on the road map to be fixed?
User | Count |
---|---|
81 | |
75 | |
73 | |
42 | |
36 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |