Forum Discussion

fheller98's avatar
fheller98
Helper I
3 years ago

Filtering new rows in data-table

Good day to all, Problem: I want a measure for the pipeline-value, which can be filtered for the specific user. Right now i get a row in the date table with the correct Pipeline-Value but i am not...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi fheller98 ,

 

You can try this code to create a measure.

M_Pipeline Worth =
VAR date1 =
    SELECTEDVALUE ( 'Date Table'[Date] )
RETURN
    CALCULATE (
        SUMX ( 'Deal-Table', 'Deal-Table'[Value] ) + 0,
        FILTER (
            'Deal-Table',
            'Deal-Table'[Create Date] <= date1
                && ( 'Deal-Table'[Close Date] > date1
                || 'Deal-Table'[Close Date] = 0 )
        )
    )

Result is as below.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • fheller98's avatar
    fheller98
    Helper I
    3 years ago

    Anonymous 
    Filtering now works - unfortunately I have another problem:

    In the data model the Create-Date & the Date (Data-Table) are related to each other.
    I think this leads to the fact that the pipeline value is separated on the individual date.

    Do you have any solution for this?