Forum Discussion
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...
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
Hi v-jiascu-msft,
I can't share de pbix original file because the data model of the previous message is a portion of the all data model. But I can especificate you the structure of each table:
| EXPEDIENTS |
| CODEXPEDIENT |
| DATEEXP |
| MASTER |
| T1 |
| CODT1 |
| COLLABORATOR |
| TYPE |
| IMPORT |
| T2 |
| CODT2 |
| COLLABORATOR |
| TYPE |
| IMPORT |
| T3 |
| CODT3 |
| COLLABORATOR |
| TYPE |
| IMPORT |
Thanks for your post.