Forum Discussion

WorldWide1's avatar
WorldWide1
Icon for Helper II rankHelper II
1 year ago
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...
Need Help
  • MFelix's avatar
    MFelix
    1 year ago

    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.

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
1 year ago

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.

 

WorldWide1's avatar
WorldWide1
Icon for Helper II rankHelper II
1 year ago

Perfect - thank you!