Forum Discussion
Converting a Tableau Measure to Power BI
Hi,
I am in the process of converting a load of Tableau dashboards into Power BI but cannot figure out how to translate this particular measure and was hoping someone could point me in the right direction:
Measure from Tableau:
SUM({INCLUDE [Site],[Platform],[Report Month],[Module] : SUM([ProductHeld])})/SUM({INCLUDE [Site], [Platform], [Report Month] : MAX([Total Production])})Any help would be appreciated
Many Thanks in advance
6 Replies
- parry2k
Super User
Anonymous can you tell what the measure actually do?
Hi parry2k and thanks for the reply.
Yes and no - Im converting this for a system ive never really used but from what I found online the "INCLUDE" is to aggregate data down as the source data has duplictate values for the products as some columns have been unpivoted.
The "INCLUDE" tells Tableau to SUM the [ProductHeld] for each variation of:
[Site],[Platform],[Report Month],[Module]
then divides by the same but is returning the MAX of totalProducts as this will be the same for multiple records
Many Thanks
Just expanding on this as Ive just though about it more logically.
The final result to show is essentially a what percent of products were held for each occurance of the Site, Module, Data & Module against the total of the total products - Issue is that the [totalProducts] column has duplicates so it would need to aggregate through the Site, Module, Data & Module again and SUM all of those together
