Learn with power BI sample data

[iruobe19]

Hello Everyone

I downloaded the power BI learn with data sample tutorial...financial samples.xlsx, which teaches how to prepare a Data sample in 20 mins, but when I got to the part..Extra credit: Write two expressions in DAX

and entered the expression...Total Units Sold = SUM(financials[Units Sold]) in the tab New Measure under the Home tab there was no response, does any have an idea why this happens

[rohit1991 · Accepted solution]

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.

[v-kpoloju-msft · Accepted solution]

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.

[v-kpoloju-msft]

Hi @iruobe19,

Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.

Thank you.

[v-kpoloju-msft]

Hi @iruobe19,

Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

Thank you.

[Praful_Potphode]

Hi @iruobe19 

when you create a measure and its written correctly with proper syntax,there will be no response.

when you create a measure and its written with improper syntax, there will be an error message.
in order to check measure try to use visuals.my personal choice is to go for card visual as it can show whether the values is coming in properly or not.you can also try visuals like table or matrix or a bar.keep in mind A measure will not work with Slicer.

Please give kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful

[rohit1991 · Accepted solution]

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.