Forum Discussion

RonaldvdH's avatar
RonaldvdH
Post Patron
4 years ago

Dynamic calculation

Ive got a visual based on a few measurements and when I use the slider the outcome for those measurements should change.

But here is my problem.

 

Ive got a datasheet with dates in them, adresses and average length per adres so basically I got this type of data

 

AdresCompletion dateAverage Length
101-04-2210
210-04-2210
3 10
4 10

 

When I set my slider (or change it) it should calculate again based on the new data for example

When I do not enter a date range it should give the following result when I calculate the adresses

 

Result should be: 2

But when I set my slider to daterange 01-04-22 through 01-04-22 the result should be 1

Aantal HP plastic Gereed = Countrows(
    Filter(
        'Civiel/HAS planning',
        'Civiel/HAS planning'[gesloten]<>BLANK()
        &&'Civiel/HAS planning'[activiteit]="Civiel"
        )
    )

 

Need Help

8 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    RonaldvdH , try something like this

     

    Aantal HP plastic Gereed = if(isfiltered('Civiel/HAS planning'[Completion date]) Countrows(
    Filter(
    'Civiel/HAS planning',
    'Civiel/HAS planning'[gesloten]<>BLANK()
    &&'Civiel/HAS planning'[activiteit]="Civiel"
    && not(isblank('Civiel/HAS planning'[Completion date]))
    )
    ) , Countrows(
    Filter(
    'Civiel/HAS planning',
    'Civiel/HAS planning'[gesloten]<>BLANK()
    &&'Civiel/HAS planning'[activiteit]="Civiel"
    && (isblank('Civiel/HAS planning'[Completion date]))
    ) ) )

    • RonaldvdH's avatar
      RonaldvdH
      Post Patron
      4 years ago

      amitchandak thanks for your help thus far but we are not there yet. It seems that it works when I set my slider to change the period but when I do NOT select anythin it should show all but now it return a BLANK value

       

      Aantal HP plastic Gereed = if(ISFILTERED('Civiel/HAS planning'[begin]), 
Countrows(
    Filter(
    'Civiel/HAS planning',
    'Civiel/HAS planning'[begin]<>BLANK()
        &&'Civiel/HAS planning'[activiteit]="Civiel"
        && not(isblank('Civiel/HAS planning'[gesloten]))
    )
) , 
Countrows(
    Filter(
    'Civiel/HAS planning',
    'Civiel/HAS planning'[gesloten]<>BLANK()
        &&'Civiel/HAS planning'[activiteit]="Civiel"
        && (isblank('Civiel/HAS planning'[gesloten]))
        )
    )
)

  • RonaldvdH's avatar
    RonaldvdH
    Post Patron
    4 years ago

    Does anyone have any ideas or is this just one of those problems with NO solution to it ?