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

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