Forum Discussion

RonaldvdH's avatar
RonaldvdH
Icon for Post Patron rankPost 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 ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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
    Icon for Post Patron rankPost 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
      Icon for Post Patron rankPost Patron
      4 years ago

      amitchandak you think you can help me figure this problem out ?