Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I'm struggling with an apparent simple problem. I have a summarized table "SA" that comes from a table "A" that has all the below columns except the highlighted one "Net Capacity".
The Net Capacity column comes from a table "B" and I'm able to include it in my report.
Table "SA" 's objective is to be a "global" table, not impacted by filters but since "Net Capacity" comes from table "B" it is affected by filters.
Problem: I want to be able to summarize "Net Capacity" from table "B" into my summarized table "SA" below so that it isn't impacted by filters. I have tried using different combinations of CALCULATE, SUMX, among other things but I didn't have any luck so far 😕
I appreciate your feedback
1. without filter
2. with filter, notice how Net Capacity changes while "Total Utilizable Hours" remains the same
@jfernand not sure if i quite understand what you asking, but if you want any measure to be static in the face of filter context you need to use the all statement
ie
totalcapacityall = calculate(sum(totalcapacity), all(tablename))
Proud to be a Super User!
Hi vanessa,
sorry, I'm not that great at explaining what I need and even worse in Power BI 🙂
I have tried the solution you gave me but couldn't get the result I wanted unfortunately. see below.
Formula used:
Net Capacity 2 Col = CALCULATE(
SUM(ahsresschedule[Net Capacity]);
ALL(ahsresschedule[Net Capacity])
)
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |