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 DAX: 

THRESHOLD_VALUE = CALCULATE(MAX(CABS_CLLI_ERROR_SUMMARY[MSG]),CABS_CLLI_ERROR_SUMMARY[QUERY_DESC]="THRESHOLD")

 

But when a try to use to compare with MSG is nor working.

CONDITIONAL_COLUMN = IF(CABS_CLLI_ERROR_SUMMARY[BILLABLE]>=[THRESHOLD_VALUE],1,0) give me 1 in all rows.
Any Suggestion?🤔
  • Change this and try

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

1 Reply

  • Change this and try

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