Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Absolute references in Power BI

Hi,

 

Is there a way to do absolute references in Power BI like there is in Excel.  Essentially I want to be able to always reference a single cell value in a table visual.

 

Thanks!

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago

    No and yes. No because DAX doesn't work that way, it deals in tables and columns, not rows and columns and cells.

     

    Yes potentially depending on what you are doing, if you can uniquely identify something in the row, you can filter down to it. So, if you add an Index column for example and you know the Index value, you can filter down to just that one row and the value in a particular column in that row.

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    8 years ago

    Hey,

     

    acutally thats not possible.

     

    To achieve something similar you can create a measure like so

    CALCULATE(
//refernce to a measure that is shown in the table visual
[measure name]
//reference to a column from a certain table
SUM('tablename'[columnname]
,FILTER(
ALL('tablename')
,tablename'[columnname 1] = filtervalue1
,...
,tablename'[columnname n] = filtervaluen
)
)

    Hopefully this gives you an idea.

     

    Regards,

    Tom