Matrix Visual not updating after selection of disconnected slicer.

[danno]

Hi, 

I'm following the design pattern of the disconnected slicer to enable units in a report to be dynamically displayed in units or divided by 1000.  The pattern is working for the base measure on its own in a table or matrix, but when including dimensions in the matrix to pivot the data, the measure will not update, unless the matrix is clicked.  This only happens when a certain measure splits the data by columns, if the dimension splits the data over rows it works fine.

The Units table has a measure Selected Display Units = IF(HASONEVALUE('Display Units'[Units]), VALUES('Display Units'[Denominator',1)   which defaults to 1 if no units are selected.  

This drives a measure in the fact table which should accept the selected display units and divide by 1000. 

Measure = DIVIDE(SUM(PnLMetricValue), Selected Display Units)

The dimensions split the measure into measure types (because the data is split over rows instead of measures in columns) 

I can't figure out if there is something happening in Power BI to do with evaluation order, or if this is just a bug with the Matrix. 

here's the screenshot with the display unit selected as 1000s. 

before the matrix is clicked the dynamic measure is not reacting, even though the matrix does indicate it is refreshing.after the matrix is clicked the dynamic measure updates 

[v-qiuyu-msft]

Hi @danno,

Please update Power BI desktop to the latest version 2.65.5313.701 then test again. 

If issue persists, please share pbix file with us. You can upload it to your Onedrive and send the share link to me via private message. 

Best Regards,
Qiuyun Yu 

[danno]

Hi, 

the issue does seem to be intermittent, and I found that closing the report and opening again seems to have resolved the issue.  

thanks

Dan

[v-qiuyu-msft]

Hi @danno,

As the issue is resolved now, may I close this thread? 

Best Regards,
Qiuyun Yu