Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 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
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 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.