Forum Discussion

DNKL's avatar
DNKL
Icon for Helper I rankHelper I
6 years ago
Solved

Line chart suddenly showing huge numbers

Hi all, I have been running into a very strange issue with PowerBI lately and I cannot seem to be able to solve it. I have created a line chart to show the running total % of customer that has been...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi DNKL ,

    It seems the formula which calculate the total number of customers(COUNTA(D_Customers[Customer code])) can't return the correct value, please try to update the formula of measure "%Sub_Tracker running total " as below:

    %Sub_Tracker running total =
    DIVIDE (
        [Sub_Tracker running total],
        COUNTX (ALL( 'D_Customers'), D_Customers[Customer code] )
    )

    If the above method still not working, please provide the related tables structure and some sample data(exclude sensitive data). Thank you.

    Best Regards

    Rena

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi DNKL ,

It seems the formula which calculate the total number of customers(COUNTA(D_Customers[Customer code])) can't return the correct value, please try to update the formula of measure "%Sub_Tracker running total " as below:

%Sub_Tracker running total =
DIVIDE (
    [Sub_Tracker running total],
    COUNTX (ALL( 'D_Customers'), D_Customers[Customer code] )
)

If the above method still not working, please provide the related tables structure and some sample data(exclude sensitive data). Thank you.

Best Regards

Rena

DNKL's avatar
DNKL
Icon for Helper I rankHelper I
6 years ago

Hi Anonymous ,

 

Thank you for your reply!

 

I tried out the DAX solution you suggested. With making a slight adjustment (using ALLSELECTED() instead of ALL()), the solution you provided works! Thank you very much for your help! 🙂

 

Best, 

DNKL