Forum Discussion

OPS-MLTSD's avatar
OPS-MLTSD
Icon for Post Patron rankPost Patron
4 years ago

What does this formula mean?

Hello everyone,   I have a dashboard that I am trying to learn from and I cam across this dax below, if someone could please explain to me what this formula means, that would be much appreciated. A...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

OPS-MLTSD Close:

VAR __ProcessLogID = Table1'[PROCESSLOGID]

VAR CLIENT_IND =CALCULATE(SUM('Table1'[Targets achieved to date (#)),FILTER(Table1',AND('Table1'[CATEGORY]="Number of Clients", [PROCESSLOGID] = __ProcessLogID))) RETURN

VAR CLIENT_SURVEY = IF(and(calculate(MAX('Table2'[Report Submission#]) = "Activity Report#1"),calculate(max(Table3[type])="5C")), calculate(SUM(Table4[INTAKE])), BLANK())

RETURN

IF(NOT(ISBLANK(calculate(COUNTROWS('Table1'),FILTER('Table1',AND('Table1'[CATEGORY]="Number of Clients", VAR __ProcessLogID))))),CLIENT_IND,CLIENT_SURVEY)
OPS-MLTSD's avatar
OPS-MLTSD
Icon for Post Patron rankPost Patron
4 years ago

Greg_Deckler thank you, I tried the above metthod and this is the error I am getting: "Cannot convert value 'C848E92ED424036BE05400144FFB2F6F' of type Text to type True/False."

 

Just wondering if you are familiar with this error message? 

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi， OPS-MLTSD ‘

    Can you post sample data as text and expected output?
    Not enough information to go on;

     

    Best Regards,
    Community Support Team_ Yalan Wu