topic Re: Recreate OLAP calculated member in a samenatic model in DAX Commands and Tips

Recreate OLAP calculated member in a samenatic model

Victornld2 — Tue, 21 May 2024 10:29:45 GMT

Hi everyone,

I'm recreating an old OLAP cube to a semantic model (in Fabric).

There is a calculated member in OLAP, but how do I recreae this in Power BI / a semantic model?

The calculated member (named: Average) calculates the sum of the weekdays, divided by 5. Deadsimple, not dynamic.

And is than added to a dimension attribute (Calendar/Day of the week).

So in a table visual when you select the Day of the week, you get the rows:

Monday, Thuesday, Wednesday, Thursday, Friday, Average.

So no matter what measue you select in the visual, the member Average always shows the average in the colums.

The OLAP visual:

Power BI semantic model visual:

Anybody got any suggestions?

UPDATE:

I resolved the challenge with a DAX measure to change the behaviour depending if the context is on the rows or the total level. IF(HASONEVALUE(), CALCULATE(),CALCULATE() ) )

Re: Recreate OLAP calculated member in a samenatic model

lbendlin — Wed, 08 May 2024 22:38:35 GMT

Repeating the same data in a visual is a design red flag.

The Table and Matrix visuals in Power BI support implicit measures, and Totals areas. Consider using these instead.

Re: Recreate OLAP calculated member in a samenatic model

Victornld2 — Mon, 13 May 2024 06:57:45 GMT

Thanks for your reaction. How would you use an implicit measure or the Totals area for this case?

Re: Recreate OLAP calculated member in a samenatic model

lbendlin — Mon, 13 May 2024 21:28:46 GMT

Re: Recreate OLAP calculated member in a samenatic model

Victornld2 — Tue, 14 May 2024 06:35:50 GMT

Thanks Ibendlin.

I understand to just change the aggregation of the value in the matrix. But if you filter on, for example, to show only monday's and thuesday's, the total value also changes (ofcourse). So I think I than need to make a dax measure. So that it on the total's level ignores the filters.

Re: Recreate OLAP calculated member in a samenatic model

lbendlin — Tue, 14 May 2024 09:24:36 GMT

Remember that you can override the measure definition for the totals areas. Make sure your users understand what you are showing as it is no longer intuitive.