Forum Discussion

SQUILES's avatar
SQUILES
Helper I
6 years ago
Solved

GET VALUE FROM TABLE

HI everyone!!! I need a little help....🙄 I have a table with with two columns (query_desc, msg), I need to get apart query_desc = threshold to use this value to compare with all MSG. I use this DA...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Change this and try

    CALCULATE(MAXX(filter(all(CABS_CLLI_ERROR_SUMMARY),CABS_CLLI_ERROR_SUMMARY[QUERY_DESC]="THRESHOLD"),CABS_CLLI_ERROR_SUMMARY[MSG]))
amitchandak's avatar
amitchandak
Super User
6 years ago

Change this and try

CALCULATE(MAXX(filter(all(CABS_CLLI_ERROR_SUMMARY),CABS_CLLI_ERROR_SUMMARY[QUERY_DESC]="THRESHOLD"),CABS_CLLI_ERROR_SUMMARY[MSG]))