Forum Discussion

mmoreira7's avatar
mmoreira7
Frequent Visitor
7 years ago

Error getting data by period

Hi everyone.    I am new to Power BI and I am facing this problem.   I´ve created this measures:   FAT ILIQUIDO = CALCULATE(SUM(FDOCDETAIL[TOTAL]);FDOCDETAIL[OPERATION_TYPE]="1") FAT ILIQUIDO ...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi mmoreira7,

 

Modify your measure like pattern below and check if it can meet your requirement:

 

FAT ILIQUIDO =
CALCULATE (
    SUM ( FDOCDETAIL[TOTAL] ),
    FILTER ( FDOCDETAIL, FDOCDETAIL[OPERATION_TYPE] = "1" )
)

Regards,

Jimmy Tao

  • mmoreira7's avatar
    mmoreira7
    Frequent Visitor
    7 years ago

    Hello Jimmy,

     

    Thank you so much for your help.

     

    Unfortunatly all remais the same. It didnt work. 

     

    Any other suggestion?