Forum Discussion

bheinrich's avatar
bheinrich
Frequent Visitor
7 years ago

Measure does not show total

Hello,

 

I have a measure that works properly on each row, but does not show the total for all of the rows in the table.  I need to multiple MBOE by NRI and divide the measure by 100.  The Data Category for this measure is greyed out, so i can't force it to show a Sum.

 

NRI_MBOE = IF(HASONEVALUE('Cost Centers'[Cost Center Key]),
    CALCULATE(VALUES(EUR_BOE[MBOE])*VALUES('Well Info'[NRI])/100),
    BLANK())

 

Thanks for any suggestions.

Need Help

5 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    7 years ago

    Hey,

     

    your measure does not a value for the Total because there is no one value for

    HASONEVALUE('Cost Centers'[Cost Center Key])

    Try this measure instead:

    IF(HASONEVALUE('Cost Centers'[Cost Center Key]),
    CALCULATE(VALUES(EUR_BOE[MBOE])*VALUES('Well Info'[NRI])/100),
    
,//HASONEVALUE returns false
CALCULATE(
    SUM(EUR_BOE[MBOE])
    ,ALLSELECTED('Cost Centers'[Cost Center Key])
)
*
CALCULATE(
    SUM('Well Info'[NRI])
    ,ALLSELECTED('Cost Centers'[Cost Center Key])
)
/100
)

    Hopefully this provides what you are looking for. Otherwise, please prepare a pbix with sample data, upload the file to onedrive or ropbox and share the link.

     

    Regards,
    Tom

    • bheinrich's avatar
      bheinrich
      Frequent Visitor
      7 years ago

      Thank you Tom! This got me closer.  There is a total showing up now, but it is not the correct total. 

      • TomMartens's avatar
        TomMartens
        Super User
        7 years ago

        Hey,

         

        I'm sorry for that, please consider to prepare a pbix with sample data, and share the link to the uploaded file (uploaded to onedrive or dropbox)

         

        Regards,

        Tom