Forum Discussion

pr1ngl3's avatar
pr1ngl3
Regular Visitor
3 years ago
Solved

Calculate calculated fields by row

Afternoon - hoping someone can put me out of my misery....   Using the above as an example... The following Tables have a relationship via a Customer Mapping table Term is a calculated colu...
  • DimaMD's avatar
    DimaMD
    3 years ago

    Hi pr1ngl3 Try it maesure

    IF( HASONEVALUE('table'[Customer]),
 [Remaining Revenue],
 SUMX( VALUES('table'[Customer]),
 [Remaining Revenue]))
DimaMD's avatar
DimaMD
Icon for Solution Sage rankSolution Sage
3 years ago

Hi pr1ngl3 Try it maesure

IF( HASONEVALUE('table'[Customer]),
 [Remaining Revenue],
 SUMX( VALUES('table'[Customer]),
 [Remaining Revenue]))
  • pr1ngl3's avatar
    pr1ngl3
    Regular Visitor
    3 years ago

    Thank you so much!! been struggling with this for a while.

    Such a quick reply too 😁