Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Measures from Analyze in Excel
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,
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?
Hello GibertQ
Will give your suggestion a try.
Much appreciate the follow up!
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?
Hello GilbertQ
Created a pivot for the following measures and refreshed
Filters Year 2021 and 2022 Selected
MTD
CY MTD$ numbers are blank
CY QTD $ numbers are blank
CY YTD $ the numbers are calculating correctly
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.