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
RonaldvdH
Post Patron
Post Patron

Changing my formula

Guys,

 

Is there a way to end the measure so that in the visual it wont display a value further then, in this case, the first blank value in 2021-32

 

The formula has a MAX value in it and that is why i think i need to change the formula

 
Running Total Sales = CALCULATE(
COUNTA( 'Sales'[Salesdate]),
FILTER (
ALL ( 'Date' ),
'Date'[Date] <= MAX('Date'[Date]) )
)

 

2021-08-03_12-37-04.png 

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Please try the below and please check whethter there is any performance issue or not.

 

Running Total Sales =
IF (
NOT ISBLANK ( COUNTA ( 'Sales'[Salesdate] ) ),
CALCULATE (
COUNTA ( 'Sales'[Salesdate] ),
FILTER ( ALL ( 'Date' ), 'Date'[Date] <= MAX ( 'Date'[Date] ) )
)
)

 

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


View solution in original post

3 REPLIES 3
rammishra
Helper II
Helper II

Hi, 

 

Did you try using ISBLANK?

 

Something like this-

 

Var a = 

CALCULATE(
COUNTA( 'Sales'[Salesdate]),
FILTER (
ALL ( 'Date' ),
'Date'[Date] <= MAX('Date'[Date]) )
)
 
Return
If(ISBLANK(a), blank(),a)

Im afraid that does nothing for the outcome, the line still continues

Jihwan_Kim
Super User
Super User

Please try the below and please check whethter there is any performance issue or not.

 

Running Total Sales =
IF (
NOT ISBLANK ( COUNTA ( 'Sales'[Salesdate] ) ),
CALCULATE (
COUNTA ( 'Sales'[Salesdate] ),
FILTER ( ALL ( 'Date' ), 'Date'[Date] <= MAX ( 'Date'[Date] ) )
)
)

 

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


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.