cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RonaldvdH
Helper V
Helper V

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 I
Helper I

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
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.