Solved: Re: Measure on dataset based on excel file

UksiDuksi · ‎09-01-2023

Hello Everyone,

Any idea why i can't use any of the columns that are visible in the source, which is excel file stored on sharepoint?

christinepayton · ‎09-01-2023

You need to put a function in there, so start typing "SUM(" and then start typing "amount" and it should populate in the dropdown.

View solution in original post

UksiDuksi · ‎09-12-2023

Thank you all for reply. Everyhing is working fine now.

ERD · ‎09-01-2023

@UksiDuksi , this article will help you to understand the difference between measures and calculated columns: https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/ and thus will answer your question.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.

Check out my latest demo report in the data story gallery.

Stand with Ukraine!

Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!

christinepayton · ‎09-01-2023

You need to put a function in there, so start typing "SUM(" and then start typing "amount" and it should populate in the dropdown.

Measure on dataset based on excel file

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024