Forum Discussion

paw1's avatar
paw1
Helper I
3 years ago
Solved

DAX Error

HI,

 

Can any one please help me to resolve the below error in DAX.

 

Thanks

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi paw1 ,

    For the divisor, do you want to get the total value of the field [Number of Records1] in the table 'Asia Pipeline Analytic - Final'? If yes, you can update the formula of your measure [Number of records %] as below to get the expected result. Please find the details in the attachment.

    Number of records % =
DIVIDE (
    SUM ( 'Asia Pipeline Analytic - Final'[Number of Records1] ),
    CALCULATE (
        SUM ( 'Asia Pipeline Analytic - Final'[Number of Records1] ),
        ALLSELECTED ( 'Asia Pipeline Analytic - Final' )
    )
)

    Best Regards

2 Replies

  • Alf94's avatar
    Alf94
    Solution Supplier
    3 years ago

    Hi paw1 ,

     

    The word "TOTAL" does not mean anything for Power BI (this is not a function, a variable you created or anything else). What did you want to compute with this measure?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi paw1 ,

    For the divisor, do you want to get the total value of the field [Number of Records1] in the table 'Asia Pipeline Analytic - Final'? If yes, you can update the formula of your measure [Number of records %] as below to get the expected result. Please find the details in the attachment.

    Number of records % =
DIVIDE (
    SUM ( 'Asia Pipeline Analytic - Final'[Number of Records1] ),
    CALCULATE (
        SUM ( 'Asia Pipeline Analytic - Final'[Number of Records1] ),
        ALLSELECTED ( 'Asia Pipeline Analytic - Final' )
    )
)

    Best Regards