Forum Discussion
Solved
Return Single Value after Selection
Greetings -- would appreciate help understanding in PBI, what would be a Fixed calculation in Tableau. (I've reviewed some posts here but not understanding). In the data set sample below, what's ha...
Hi WorldWide1 ,
I assume when you refer to a table you mean a visualization create the following 3 measures:
LR SCAC = MINX(TOPN(1, 'Table', 'Table'[Total Cost], ASC), 'Table'[SCAC]) Total Cost Value = MINX(TOPN(1, 'Table', 'Table'[Total Cost], ASC), 'Table'[Total Cost]) Code Value = MINX(TOPN(1, 'Table', 'Table'[Total Cost], ASC), 'Table'[Code])Now add the ID to a table and the measure you should get the following result.
Hi WorldWide1 ,
I assume when you refer to a table you mean a visualization create the following 3 measures:
LR SCAC = MINX(TOPN(1, 'Table', 'Table'[Total Cost], ASC), 'Table'[SCAC])
Total Cost Value = MINX(TOPN(1, 'Table', 'Table'[Total Cost], ASC), 'Table'[Total Cost])
Code Value = MINX(TOPN(1, 'Table', 'Table'[Total Cost], ASC), 'Table'[Code])
Now add the ID to a table and the measure you should get the following result.
Perfect - thank you!
