Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ArchStanton
Continued Contributor
Continued Contributor

IF Statement

Hi,

 

I have the following code that works just fine when calculating the difference between Case Start & Case End when there is only 1 row of data, but when there are 2 row the total is doubled: 22 x 2 = 44, the answer is 22

 

ArchStanton_1-1661248928023.png

 

How can I modify this calculated column so that it doesn't double the Total Case Length? I know I can switch of the SUMMARISE feature in the visual but is there another way?

I am using a calculated column on purpose for this 

 

Total Case Length = 
    VAR _CaseStart = 'Deferrals'[Case Start]
    VAR _CaseEnd = 'Deferrals'[Case End]
    VAR _Table = FILTER(ALL('Date'),[Date] >= _CaseStart && [Date] <= _CaseEnd && [Is Working Day] = TRUE ())
RETURN
    IF(Deferrals[Count]>1,?,COUNTROWS(_Table)

 

 

Many thanks,

 

2 REPLIES 2
amitchandak
Super User
Super User

@ArchStanton , I think to do the total use summarize of values

 

Sumx(Values(Table[TIcket No]), [measure Total case length ])

Hi, 

I don't follow, what Values are you referring to in your example?

I tried a number of combinations and none of them work.

Also, I'm not using a measure because when I do I get the wrong result - I need a row context for this.

I would like to keep this as a calculated column if possible?

 

Thanks,

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.