How to fix PowerBI formula - DAX has red line with no error code

Question

I am trying to run some analysis, and typed a formula to attempt to do so, but the DAX is giving me the redline error, with no error message.

I have no idea why this formula wont run, so any suggestions would be appreciated. Here is a screenshot:

Tried recreating the formula, modifying, etc, but nothing would push it through. Any help would be super appreciated.

Also a copy of the formula:

Customer Retention % = 
VAR CurrentMonthAfter = SELECTEDVALUE('Months After'[Value])
VAR CurrentFirstOrderMonth = SELECTEDVALUE('JOD REPORTS'[First Order Date (EOM)])
Return
DIVIDE(
    CALCULATE(
        DISTINCTCOUNT('JOD REPORTS'[Customer Number]),
        FILTER(
            'JOD REPORTS',
            EOMONTH('JOD REPORTS'[Order Date],0) = EOMONTH(CurrentFirstOrderMonth,CurrentMonthAfter)
        )
    ),
    DISTINCTCOUNT('JOD REPORTS'[Customer Number])
)

Pass your cursor on the red rectangle in the right bottom side — user9517769
– user9517769, Commented Sep 1, 2024 at 12:35
@AmiraBedhiafi No dialogue box pops up when I hover the red. It only shows up when I am on the very outside of the textbook, and doesnt give any prompts, error codes, popups, etc — user27154454
– user27154454, Commented Sep 1, 2024 at 15:30
I have a doubt with your numerator have you tried using variables? — user9517769
– user9517769, Commented Sep 1, 2024 at 19:54

user9517769 · Accepted Answer · 2024-09-01 19:58:43Z

0

I have a doubt with your numerator so you may need to use variables to make your code easier to read and debug :

Customer Retention % = 
VAR CurrentMonthAfter = SELECTEDVALUE('Months After'[Value])
VAR CurrentFirstOrderMonth = SELECTEDVALUE('JOD REPORTS'[First Order Date (EOM)])
VAR CurrentEOMonth = EOMONTH(CurrentFirstOrderMonth, CurrentMonthAfter)

VAR DistinctCustomerCount =
    CALCULATE(
        DISTINCTCOUNT('JOD REPORTS'[Customer Number]),
        FILTER(
            'JOD REPORTS',
            EOMONTH('JOD REPORTS'[Order Date], 0) = CurrentEOMonth
        )
    )

VAR TotalDistinctCustomerCount = DISTINCTCOUNT('JOD REPORTS'[Customer Number])

RETURN
DIVIDE(DistinctCustomerCount, TotalDistinctCustomerCount)

answered Sep 1, 2024 at 19:58

user9517769

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to fix PowerBI formula - DAX has red line with no error code

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related