cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Converting Tableau Fixed LOD to Power BI

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*
FacilityProjected 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:
FacilityProjected Budget Over/Under 3Projected Budget Over/Underprojectedoverunder *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
 
 
 

 Thank you in advance!!

 
1 REPLY 1
Highlighted
Community Support
Community Support

Hi @rachelbabcock 

 

Not quite understand your requirement, could you plz kindly share your original sample and expected results?

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors