Solved: Re: DAX Error

paw1 · ‎04-14-2023

HI,

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

Thanks

Anonymous · ‎04-20-2023

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

View solution in original post

Anonymous · ‎04-20-2023

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

Alf94 · ‎04-14-2023

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?