Bug DAX Editor

[PalombieChamonix]

The DAX editor has a strange behevior since the last release, which makes it very frustrating to use !!

[jbrizido]

Happens to me too. Although it does not happen in all reports.

[BitwalkerSthlm]

Me too, although it only happens in proximity to a collapsible section. I hade to revert to 3.4.2 to be able to work.

[mlonsk]

Hi @PalombieChamonix
Are you working in the expression editor or in a DAX Script and does it happen in both?

[mlonsk]

Hi @PalombieChamonix , @jbrizido & @BitwalkerSthlm

I am having a bit of trouble reproducing the issue in the GIF. Would it be possible to share some DAX code as well as a description of each step taken to trigger the bug?
Thank you

[BitwalkerSthlm]

I only use the Expression Editor, so that's where the issue occurred for me. I reverted back to the previous version, so I can't record anything, but for instance, it happened when I positioned the cursor at the start of the row above RETURN, in the measure below, and hit enter.

VAR VAR_MinDate = MIN('DIM Dates'[Day Date])
VAR VAR_MaxDate = MAX('DIM Dates'[Day Date])
VAR VAR_ReEmployLimit = [Re-employment Limit]

VAR VAR_Employees =  
      
    CALCULATETABLE(
        SUMMARIZE(
            FILTER( 'DIM Employment Details',
                
                --Has ended row
                'DIM Employment Details'[Row Valid To] >= VAR_MinDate &&
                'DIM Employment Details'[Row Valid To] <= VAR_MaxDate &&
                
				--Räkna bara de som avslutat en fast anställning
				'DIM Employment Details'[Employment Basic Type] = "Permanent Employment" &&
				
				--Ingen senare fast anställning samma år
				'DIM Employment Details'[E Following Permanent Rows Same Year] = FALSE &&
				
				--Now other employments which interfere
				(
					'DIM Employment Details'[E Has Future Fixed-term Row] = FALSE ||
					'DIM Employment Details'[E Has Future Fixed-term Row] = TRUE && 'DIM Employment Details'[E Gap to Future Fixed-term Row] >= VAR_ReEmployLimit
				) &&
				(
					'DIM Employment Details'[E Has Future Permanent Row] = FALSE ||
					'DIM Employment Details'[E Has Future Permanent Row] = TRUE && 'DIM Employment Details'[E Gap to Future Permanent Row] >= VAR_ReEmployLimit
				)
                
            )
            , 'DIM Employment Details'[Employee Id]
        )
        , TREATAS( VALUES( 'DIM Organization'[Cost Center MDS Code] ), 'DIM Employment Details'[Cost Center MDS Code] )
        , TREATAS( VALUES( 'DIM Employees'[Employee Id] ) ,'DIM Employment Details'[Employee Id])
    )

RETURN
    
    IF(
        ISFILTERED( 'DIM Dates' ) = FALSE,
        
        BLANK(),
        
        CALCULATE( 
            DISTINCTCOUNT('DIM Employees'[Employee Id]), 
            TREATAS( VAR_Employees, 'DIM Employees'[Employee Id] )
        
    )
    )

[otykier]

Great repro, thanks @BitwalkerSthlm!

[otykier]

Update: We're working on fixing this issue. In the mean time, you can prevent the issue by disabling "Auto-indent" in the Tools > Preferences > Text Editors > DAX Editor > Auto Formatting page.

[BitwalkerSthlm]

Great, thanks!!

[PalombieChamonix]

Many thanks !!! TE is so critical for us !! YouKey

…

________________________________ De : BitwalkerSthlm ***@***.***> Envoyé : Friday, March 24, 2023 11:27:43 AM À : TabularEditor/TabularEditor3 ***@***.***> Cc : Marc LEMPEREUR ***@***.***>; Mention ***@***.***> Objet : Re: [TabularEditor/TabularEditor3] Bug DAX Editor (Issue #857) Great, thanks!! — Reply to this email directly, view it on GitHub<https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FTabularEditor%2FTabularEditor3%2Fissues%2F857%23issuecomment-1482577449&data=05%7C01%7Cmarc%40youkey.fr%7Cd5adf8d0cba3425c2b2108db2c526845%7C1ddf80fd35ab40ab994826984cd2818e%7C0%7C0%7C638152504674212814%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=T4%2B1VOf8pmgIfM6JWVzyGs0CVLSvpI1hqg5a4eJxQio%3D&reserved=0>, or unsubscribe<https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAVYJC746C6OHTZ2J4THDAFTW5VZJ7ANCNFSM6AAAAAAWCX56HA&data=05%7C01%7Cmarc%40youkey.fr%7Cd5adf8d0cba3425c2b2108db2c526845%7C1ddf80fd35ab40ab994826984cd2818e%7C0%7C0%7C638152504674212814%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=K9nVl0UrLrTjfONoWZ%2Fluz1ClLSJ9B0RCuGkvbSm2LY%3D&reserved=0>. You are receiving this because you were mentioned.Message ID: ***@***.***>

[otykier]

This is fixed in 3.5.1. After installing 3.5.1, the issue should no longer appear, even when re-enabling Auto-indent.

[CraigsterT]

There seems to be a new issue in 3.5.1. When I am typing out a simple measure , for instance , Sales YTD , I start the measure CALCULATE( [Sales Amount] , and at this stage the closing parenthesis for CALCULATE() suddenly vanishes and has to be retyped. Is this a bug in the editor ?

…

On Wed, Mar 29, 2023 at 12:06 AM Daniel Otykier ***@***.***> wrote: Closed #857 <#857> as completed. — Reply to this email directly, view it on GitHub <#857 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AP2MVAULYCGMU2KLGZQ34BLW6NVGHANCNFSM6AAAAAAWCX56HA> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.*** com>