Forum Discussion
Not recognise data table when making measures
Hello,
I'm quite new with Power BI. I have data in the tables but when I try to make a measure I can not see this data to make the measure.
Ex:
But I have a table "Ventas" with different data:
As you can see in the first picture does not recognise the data from "Ventas" only from the measures I created.
What am I doing wrong??
Thank you in advance!
P
7 Replies
Thank you David for your answer. I have the data with the right format and still the same, does not recognise it.
Usually this has to do with data type. If these tables and columns are formatted as text a lot of the functions won't recognize them as able to use SUM or CALCULATE as they see no numbers to sum or calculate. I've run into this with different datasources from time to time as well.
In Power Query -- "Transform Data" -- Look at the data type of the columns in the table in question and try transforming them. This should help them show up to be able to make measures with.
This is due to context. In a measure you when you are outside of a funtion you cannot reference tables or columns, only measures. Within functions you can access tables and columns
I.e. values( ventas[id Tipo])
If you were creating a calculated column you have a explict row context from that table and can reference columns from that table
Hi polfm,
Thanks for reaching out to the Microsoft fabric community forum.
It looks like you are facing issues while creating measure from your data which is stored in tables. As Deku and d_m_LNK both responded to your query, please go through the response and mark the helpful response as solution.
I would also take a moment to thank Deku and d_m_LNK, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support TeamIf this post helps then please mark it as a solution, so that other members find it more quickly.
Thank you.
Hi polfm,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.Hi polfm,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily.
Thank you.
