Hello,
I am struggling to convert a series of Tableau Fixed LOD's in my Power BI report. I have read just about every post on this matter that is currently on the discussion board and have not been able to figure out an answer. If I can figure at least this one out, I think I can figure out the rest.
The Tableau LOD reads as follows:
Projected Over Under = { FIXED [Project Name],[accountcode],[projectedoverunder]: AVG([projectedoverunder])}
I've tried the following, which you'll see in the table below:
1) Creating a calculated column using the following formula:
Projected Budget Over/Under = CALCULATE(AVERAGE(Query1[projectedoverunder]), ALLEXCEPT(Query1, Query1[name], Query1[accountcode], Query1[projectedoverunder])). This simply provides the same value as the original field, "projectedoverunder" (also included in the table for reference.) **I've tried this same formula but using ALLEXCEPT for each field -- name, account code, and projected over under and get the exact same resutls**
2) Taken a similar approach using measures. I created the following:
Projected Budget Over/Under 3 = CALCULATE(([Projected Budget Over/Under2]), ALLEXCEPT(Query1, Query1[name]), ALLEXCEPT(Query1, Query1[accountcode]), ALLEXCEPT(Query1, Query1[projectedoverunder])). This gives me the same value across the table.
Projected Budget Over/Under 2 measure, referenced above, is:
Projected Budget Over/Under2 = AVERAGE(Query1[projectedoverunder])
I cannot seem to get the correct results to display. Any help would be MUCH appreciated.
What the results should be *note that some are correct; others are not. I'm guessing that the ones that are incorrect have to do with the way that average is occuring based on the other fields*
| Facility | Projected Budget Over/Under |
| Facility 1 | -52 |
| Facility 2 | -450,000 |
| Facility 3 | -874, 373 |
| Facility 4 | -1,500,000 |
| Facility 5 | -1,608,053 |
How the results display:
| Facility | Projected Budget Over/Under 3 | Projected Budget Over/Under | projectedoverunder *original field from dataset* |
| Facility 1 | -125,577.19 | -412 | -412 |
| Facility 2 | -125,577.19 | -450,000 | -450,000 |
| Facility 3 | -125,577.19 | -5,186,480 | -5,186,480 |
| Facility 4 | -125,577.19 | -1,500,000 | -1,500,000 |
| Facility 5 | -125,577.19 | -55,850,173 | -55,850,173 |
