Forum Discussion
Learn with power BI sample data
- 10 months ago
HI iruobe19
This usually happens if the measure wasn’t created correctly or if the table/column name doesn’t match your model.
Could you please try below steps:
1.In Power BI Desktop, go to the Modeling tab>>click New Measure.
2.Type this exactly:
Total Units Sold = SUM(Financials[Units Sold])and press Enter.
3.You’ll now see the measure under the Financials table in the Fields pane.
4.To view the result, drag Total Units Sold into a Card or Table visual , it won’t show any output until you use it in a visual.
Also, make sure the table name is Financials (same spelling and capital letters) and that Units Sold is a numeric column.
- 10 months ago
Hi iruobe19,
Thank you for reaching out to the Microsoft fabric community forum. Also, thanks to Praful_Potphode, rohit1991, for those inputs on this thread. I reproduced the scenario, and it worked on my end. I used it as sample data and successfully implemented it.
outcome:
I am also including .pbix file for your better understanding, please have a look into it.
Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.
Thank you for using the Microsoft Fabric Community Forum.
Hi iruobe19,
Thank you for reaching out to the Microsoft fabric community forum. Also, thanks to Praful_Potphode, rohit1991, for those inputs on this thread. I reproduced the scenario, and it worked on my end. I used it as sample data and successfully implemented it.
outcome:
I am also including .pbix file for your better understanding, please have a look into it.
Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.
Thank you for using the Microsoft Fabric Community Forum.