Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PBI-Curious
Resolver I
Resolver I

Dax Measures in Power BI Desktop vs. Dax Measures in Analyze in Excel

Hello PBI Community

 

I'm trying to use my Dax Measures from my .pbix in Analyze in Exel from the Power BI Services, but they are working as expected or as they would work in my .pbix.

 

Please advise some insight as to how to use my Dax Measures created in my .pbix, so I can utilize in Analyze in Excel.

 

Any questions, please advise.

Much appreciate your time.

 

Thank you

Screen Shot of my measures from my .pbix

PBICurious_0-1654095633785.png

Measures from Analyze in Excel

  • Measures are not working as they worked in my .pbix.

 

PBICurious_1-1654095900837.png

 

8 REPLIES 8
PBI-Curious
Resolver I
Resolver I

Hello GibertQ

To confirm, My YTD measures are populating numbers, but I'm getting blanks for the measures circled in red. Also all measures in my .pbix are populating numbers correctly.

Regards,

 

PBICurious_0-1654618649507.png

 

Hi @PBI-Curious 

 

Are there any filters in your Excel spreadsheet?

 

Also maybe you need to add in a filter to get the other measures to work, in that they need something to get them working?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hello GibertQ

Will give your suggestion a try.

Much appreciate the follow up!

 

GilbertQ
Super User
Super User

Hi @PBI-Curious 

 

What is not happening when using it with Excel?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hello GilbertQ

I'm getting blanks, no data is populating when I pull in the measures above into my Pivot table.

Regards,

Hi @PBI-Curious 


What happens when you drag in a single measure?

 

And what happens if you click on Refresh, does it refresh successfully?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hello GilbertQ

Created a pivot for the following measures and refreshed

Filters Year 2021 and 2022 Selected

MTD

CY MTD$  numbers are blank

PBICurious_1-1654179549953.png

CY QTD $ numbers are blank

PBICurious_2-1654179696564.png

CY YTD $ the numbers are calculating correctly

PBICurious_3-1654180154095.png

Regards,

 

 

 

 

Hi @PBI-Curious 

 

If the numbers are working when you select a Month, you then need to look at your measure to see how to resolve this. 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.