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
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 ?

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        4 years ago

        RonaldvdH , Try 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"
        )
        ) ) )

         

        I need data with all these columns with expected output sample to work on file