Absolute references in Power BI

[Anonymous]

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!

[TomMartens]

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

[Greg_Deckler]

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.