Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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() ) )
Solved! Go to Solution.
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.
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.
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.
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.
Thanks for your reaction. How would you use an implicit measure or the Totals area for this case?
User | Count |
---|---|
53 | |
45 | |
19 | |
16 | |
14 |
User | Count |
---|---|
108 | |
56 | |
29 | |
21 | |
17 |