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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors