Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Tors
Frequent Visitor

Datatype not showing in calculated table using INFO.VIEW.MEASURES()

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()

Tors_1-1738840485727.png


Datatypes in Calculated Table using INFO.VIEW.MEASURES()

Tors_2-1738840599054.png



Thank you!

1 ACCEPTED SOLUTION
rajendraongole1
Super User
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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

2 REPLIES 2
rajendraongole1
Super User
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.





Did I answer your question? Mark my post as a solution!

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?

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors