Issue Analysis

The provided DAX code snippet is designed to determine the number of records in the NEW.DIM_Bills table that meet certain criteria based on the DisconnectDate. However, the code has several issues:

1. Syntax Errors: The DAX expression has missing parentheses and improper usage of functions.
2. Use of Generate: The GENERATE function is not necessary in this context as it complicates the expression.
3. Filtering Logic: The FILTER function is not correctly implemented, particularly in the condition being checked for DisconnectDate.

Proposed Solution

This solution will focus on simplifying the DAX expression to achieve the intended goal while correcting any syntax issues. The goal is to count the records where the DisconnectDate is blank.

Corrected DAX Code

Disco Yes/No = 
VAR DiscoRows =
    FILTER(
        SUMMARIZE(
            'NEW.DIM_Bills',
            'NEW.DIM_Bills'[UserName],
            'NEW.DIM_Bills'[DisconnectDate],
            'NEW.DIM_Bills'[BillId]
        ),
        ISBLANK('NEW.DIM_Bills'[DisconnectDate]) // Check for blank DisconnectDate
    )
RETURN
    COUNTROWS(DiscoRows) // Count the rows in the filtered results

Explanation of Changes

1. Filtered Rows: The FILTER function is now applied correctly to summarize the rows where DisconnectDate is blank using ISBLANK.

2. Removed GENERATE: The use of GENERATE is removed because FILTER combined with SUMMARIZE directly provides the necessary logic.

3. Correct Parentheses: The parentheses have been properly closed to ensure the code runs without syntax errors.

Code Usage Example

To utilize the above DAX measure within a Power BI report:

1. Create a Measure:

   • In Power BI Desktop, go to the Modeling tab and select New Measure.
   • Copy and paste the corrected DAX code above.

2. Visualize the Output:

   • Drag and drop the new measure Disco Yes/No into a visual such as a card or table to see the count of users with blank disconnect dates.

Conclusion

The revised DAX formula now accurately counts the unique instances where the DisconnectDate is blank within the specified table. This solution is streamlined for technical efficiency and clarity, ensuring that it adheres to DAX best practices.