DAX Measures Disappear on Refresh

Anything related to PowerPivot and DAX Formuale
jagnew
Posts: 5
Joined: Tue Jul 21, 2020 1:56 am

DAX Measures Disappear on Refresh

Postby jagnew » Sat Aug 15, 2020 1:50 am

Hello,

I'm fairly new to PowerPivot. I created various measures within a Pivot Table and added new records to the data. When I refresh the pivot table, all of my DAX measures disappear. Why is this happening and is there a way to fix this? I will be adding new records to the data source daily.

Thanks!

MattAllington
Posts: 1150
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: DAX Measures Disappear on Refresh

Postby MattAllington » Sun Aug 16, 2020 8:57 am

This is not normal. What do you mean they “disappear”? How old is your version of Excel? Power Pivot has been pretty flakey, and the more recent the version, the better. Even O365 has lots of different versions.
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

jagnew
Posts: 5
Joined: Tue Jul 21, 2020 1:56 am

Re: DAX Measures Disappear on Refresh

Postby jagnew » Tue Aug 18, 2020 12:08 pm

Hi Matt,

I believe I have version 16. What happens is that I have to click change data source so I can include the new records. Once I refresh the pivot table all of the measures go away and are no longer part of the pivot table anymore.

jagnew
Posts: 5
Joined: Tue Jul 21, 2020 1:56 am

Re: DAX Measures Disappear on Refresh

Postby jagnew » Tue Aug 18, 2020 12:09 pm

I can send the file if you want to look at it.


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 2 guests

cron