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
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