Forum Discussion
SQUILES
6 years agoHelper I
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
- amitchandakSuper User
Change this and try
CALCULATE(MAXX(filter(all(CABS_CLLI_ERROR_SUMMARY),CABS_CLLI_ERROR_SUMMARY[QUERY_DESC]="THRESHOLD"),CABS_CLLI_ERROR_SUMMARY[MSG]))