Forum Discussion
Nested FIXED LOD (tableau) to dax
Hi maddypena07 ,
I updated your sample pbix file(see the attachment), please check if that is what you want. You can create a measure as below to get it:
Sum of Uptime by Week = SUMX ( ALLEXCEPT ( 'dummt', 'dummt'[ISO Week] ), [Uptime (hrs)] )Best Regards
Community Championmaddypena07 I don't really speak Tableau so much of the jargon is going over my head. What is it that you are having an issue with spefically. As in, which of the numbers you are trying to create is wrong? Everything looks good in your 2 images.
Thanks Greg!
I apologize for the confussion!. The final result of the tableau calculation (first image) should be:
the value 4883 on every row. I separated both FIXED results to try to resolve it steb by step.
I can get to the first part of the calculation (Inner fixed), the
{fixed [Weeks],[MachineID]:
sum([Uptime (hrs.)])}
And I get the results as the last image, but I don't know how to get that final result as a value for every row on the table.
Hi maddypena07 ,
I updated your sample pbix file(see the attachment), please check if that is what you want. You can create a measure as below to get it:
Sum of Uptime by Week = SUMX ( ALLEXCEPT ( 'dummt', 'dummt'[ISO Week] ), [Uptime (hrs)] )Best Regards