Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Fixed Calculations in PBI

 

 

I am converting a tableau workbook to PBI.

 

is there a way to perform a fixed calculation in PBI?

 

Below is the link to the fixed calculation function in Tableau.

Tableau fixed calculation 

Need Help
  • danextian's avatar
    danextian
    6 years ago

    hi Anonymous ,

    When you say fixed calculation, you mean the result of a calculation doesn't change no matter what filter you choose? You can do something like:

    calculation =
CALCULATE ( SUM ( Table[Column] ), ALL ( Table ), ALL ( Table2 ) )

    This fixes the result of an expression regardless of the filters applied to the tables in the model that are included in the formula. Or you can just fix the calcuation for a particular column. The formula below removes any active filteres to Column2 but will be filtered if filters are applied to any other column. 

    calculation =
CALCULATE ( SUM ( Table[Column] ), ALL ( Table[Column2] ) )

    There's a good read in sqlbi - https://www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept/. If you are new to this, though, it will take sometime to digest it.