Graph on the page re-calculates after creating new measures

[Anonymous]

I'm developing a dashboard on the desktop and one of the graphs on the page refreshes and recalculates whenever I make a change to my measures. For example I create a new measure that has nothing to do with the measures shown on this graph, but it still recalculates and slows down my process. 

Is this a bug? 

Here's the measure used on this graph, in case it's relevant:

Churn per Sjangergruppe =

var _min= MIN('Date'[Date])

var _max= MAX('Date'[Date])

var akt = CALCULATE(

DISTINCTCOUNT(subscription[user_id]),FILTER( subscription,

subscription[Churn]<= _max &&

subscription[Churn]>= _min //started on that date

), CROSSFILTER(users[user_id], subscription[user_id], Both))

return IF(ISBLANK(akt), 0,akt)

Churn % per Sjangergruppe = var _prevend = MIN('Date'[Date])-1

--var _prevstart = DATE(YEAR(_prevend), MONTH(_prevend), 1)

var _prevbetalende =

CALCULATE(

DISTINCTCOUNT(subscription[user_id]),FILTER(subscription,

(ISBLANK(subscription[expiry]) //still subscriber

|| subscription[expiry]>= _prevend) //or was active that date but ended now

&& subscription[start]<= _prevend // and started before that date

&&(ISBLANK(subscription[trial_end])

|| subscription[trial_end] < _prevend)),

CROSSFILTER(subscription[user_id], users[user_id], Both))

return [Churn per Sjangergruppe] / _prevbetalende

[v-cazheng-msft · Accepted solution]

Hi @Anonymous 

It should not a bug but a feature of Power BI. Although the calculation result will not be saved in the model, Measures will be saved in the model. When you create a Measure or make some changes to the Measure, the information or calculation logic of the Measure in the model will change. In the Desktop, the visuals on the pages will be refreshed once the model changes. You can simplify your calculations  to the Measures or Calculated columns to speed up the refresh process.

Best Regards

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Well, you've got 2 alternatives to check:

1. It may be that the measure you're changing/creating, indeed, does not have anything to do with the data/tables/measures that affect your graphs. If the recalc still happens, then it happens out of necessity and it's a feature, not a bug 😂. With Microsoft you never know...

2. It may be that the measure does affect something that in turn affects your graph. Hence the recalc. You might not even be aware of what it is.

The best thing to check what's going on is to create a very simple model (but with a lot of data in the fact table, so that the measure you use for the graph takes a while to calculate the values) where you know exactly what happens and then create a graph and then create a new measure and see if any recalc still happens. This is what I would do.