Forum Discussion

Raul's avatar
Raul
Post Patron
8 years ago

Measure IF Function

Hello everyone. I have the following data model:     And the following measure: Invoiced = VAR        LinT1= CALCULATE(SUM(T1[Import]); T1[Type]=1) VAR       LinT2 = CALCULATE(SUM(T...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Raul,

 

Can you share your dummy pbix file please? Or the original data. I have no idea about "C3, C4". Which table do these columns belong to? Maybe you can try it like this:

Min(Expedients[Master]) = min(expendients[MASTER])

Best Regards,

Dale

Raul's avatar
Raul
Post Patron
8 years ago

Hi v-jiascu-msft,

The result of this formula is not correct. Always return false.

Any other suggestion?

  • Raul's avatar
    Raul
    Post Patron
    8 years ago

    Ok, I have a new situation. I have managed to show in a new column (ISMASTER) into the table a 1 value if a condition is true and a 0 value if it is not. Now I need to know how to evaluate the value of each record in one measure to obtain one result or another.

     

    This is the matrix visualization:

    CODEXPEDIENTTOTALMax ISMASTER
    E1 $       113,750
    E3 $    1.010,000
    E23 $          39,500
    E24 $          55,251
    E30 $                 -  1
    E32 $          16,250

     

    I want a new measure to obtain this result:

    Measure = IF(T1.[ISMASTER] = 1; SUM(T1.[Import]); SUM(T2.[Import]))

     

    What should be the condition of the IF function? Thank you.