Forum Discussion

RonaldvdH's avatar
RonaldvdH
Post Patron
5 years ago
Solved

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 i...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    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] ) )
    )
    )

     

     

rammishra's avatar
rammishra
Helper II
5 years ago

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)
  • RonaldvdH's avatar
    RonaldvdH
    Post Patron
    5 years ago

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