Forum Discussion

danni1979's avatar
danni1979
Regular Visitor
6 years ago
Solved

Tableau LOD Fixed to Power BI

Hi All, We are really struggling converting Tableau reports to Power BI where the FIXED function is used. I can get the correct value at detail level but i can't get a correct total.   Below is a ...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    danni1979 this measure will do it, change column name and table name as per your model

     

    Amount Owed Sum = 
SUMX ( 
    VALUES ( 'Table'[Debt ID] ), 
    CALCULATE (
        MAX ('Table'[Amount Owed] ),
        ALLEXCEPT ('Table','Table'[Debt ID] )
    ) 
)
parry2k's avatar
parry2k
Super User
6 years ago

danni1979 this measure will do it, change column name and table name as per your model

 

Amount Owed Sum = 
SUMX ( 
    VALUES ( 'Table'[Debt ID] ), 
    CALCULATE (
        MAX ('Table'[Amount Owed] ),
        ALLEXCEPT ('Table','Table'[Debt ID] )
    ) 
)
danni1979's avatar
danni1979
Regular Visitor
6 years ago
Thanks, will try this today on our more complex data set and let you know how it goes.