Forum Discussion

Alyona_BI's avatar
Alyona_BI
Icon for Helper II rankHelper II
4 years ago
Solved

Retrieve the value from text field based on condition and put it in each row in the table

Hi all!  I have the task and I can't find the solution by myself and didn't find any solution at forum, so I am really hope for your help.    I have the following table:  Plant Product Value...
Need Help
  • sturlaws's avatar
    sturlaws
    4 years ago

    It is because you have not created the separate product-table, I have updated the pbix-file you shared here pbix

Alyona_BI's avatar
Alyona_BI
Icon for Helper II rankHelper II
4 years ago

sturlaws hi! Thanks for your help. 

I have my own a little bit similar calculation: 

VAR _Table = CALCULATETABLE(
GROUPBY(Table,
Table[Plant],
"ND", SUMX(CURRENTGROUP (), Table[Value]))
)
VAR _Max = MAXX(_Table, [ND])
RETURN MAXX(FILTER(_Table, [ND] = _Max), [Plant])
 
It doesn't work. Unfortunately your variant too. The result is: 

So the result in each row should be "Packer-Deparker", which we see in the Total row, but not in all rows (( 

 

Maybe you have an idea why this is so?

sturlaws's avatar
sturlaws
Icon for Resident Rockstar rankResident Rockstar
4 years ago

It is because you have not created the separate product-table, I have updated the pbix-file you shared here pbix

  • Alyona_BI's avatar
    Alyona_BI
    Icon for Helper II rankHelper II
    4 years ago

    It works. Many thanks!