Forum Discussion
MEDIDAS EN POWER BI
Cuando creo una medida no reconoce los campos de la tabla que hay cargada.
Hey DARCESEGURA ,
Few things to check:
-
Column Visibility: Ensure the fields you intend to use in your measure are visible in the report’s data model. It’s possible that certain columns might be hidden or excluded from the model view, which would prevent them from being accessed in your measures.
-
Data Type Compatibility: Confirm that the data types of the fields you're using are appropriate for the calculations in your measure. For example, if you are performing mathematical operations, ensure the fields are numeric and not text or other incompatible types.
-
Correct Table Reference: Verify that you’re referencing the correct table when defining the measure. If you're pulling data from a related table, ensure there are proper relationships established between them so the fields are recognized appropriately.
-
Relationships: When creating a measure that requires fields from multiple tables, ensure active relationships are in place between those tables. If a relationship is inactive or missing, it may lead to errors or incorrect results.
-
Measure Syntax: Double-check the syntax of your DAX formula. Often, issues arise from how the measure is written, rather than from the tables or columns being used.
For Detailed Information:
If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.
Best Regards,
Nasif Azam-
6 Replies
- FBergamaschi
Super User
Hi DARCESEGURA
with only these short words, nobody can help you here. I can only guess you are not giving context to the calculation you are creating. In a measure, you need to aggregate using MAX / MIN / AVG....
If you want more help, please include, in a usable format, not an image, a small set of rows for each of the tables involved in your request and show the data model in a picture, so that we can import the tables in Power BI and reproduce the data model. The subset of rows you provide, even is just a subset of the original tables, must cover your issue or question completely. Do not include sensitive information and do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided and make sure, in case you show a Power BI visual, to clarify the columns used in the grouping sections of the visual.
Need help uploading data? click here
Want faster answers? click here
- DataVitalizer
Holla DARCESEGURA
Asegúrate de que los datos estén completamente cargados en el modelo, también verifica que estés creando una medida y no una columna calculada, porque si eliges lo incorrecto, los campos no aparecerán.Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡 - Nasif_Azam
Hey DARCESEGURA ,
Few things to check:
-
Column Visibility: Ensure the fields you intend to use in your measure are visible in the report’s data model. It’s possible that certain columns might be hidden or excluded from the model view, which would prevent them from being accessed in your measures.
-
Data Type Compatibility: Confirm that the data types of the fields you're using are appropriate for the calculations in your measure. For example, if you are performing mathematical operations, ensure the fields are numeric and not text or other incompatible types.
-
Correct Table Reference: Verify that you’re referencing the correct table when defining the measure. If you're pulling data from a related table, ensure there are proper relationships established between them so the fields are recognized appropriately.
-
Relationships: When creating a measure that requires fields from multiple tables, ensure active relationships are in place between those tables. If a relationship is inactive or missing, it may lead to errors or incorrect results.
-
Measure Syntax: Double-check the syntax of your DAX formula. Often, issues arise from how the measure is written, rather than from the tables or columns being used.
For Detailed Information:
If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.
Best Regards,
Nasif Azam -
v-karpurapudCommunity Support
Hi DARCESEGURA
Thank you for posting your question on the Microsoft Fabric Community Forum, and thanks as well FBergamaschi , DataVitalizer and Nasif_Azam for your support and assistance.
Could you let us know if the suggested solution resolved your issue? This information can assist other community members facing similar challenges.
Thank you.
- v-karpurapud
Hi DARCESEGURA
I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.
Thank You. - v-karpurapud
Hi DARCESEGURA
We haven't received a response to our last message and wanted to follow up to see if you have found a solution. If you still need help, please share more details so we can assist you further.
Thank you.
