Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Need help - Report Filtering

Hi   I need help set up a somehwat complex filter for my report.   I have a large data set that has a column titled, 'Decscription' which, contains a number of stages within my companies completi...
Need Help
TeigeGao's avatar
TeigeGao
Solution Sage
7 years ago

Hi Anonymous ,

I think your environment like below:

We can use the following measure to filter it:

Measure =
IF (
    MIN ( Table1[TaskId] ) = 30,
    IF (
        CALCULATE (
            MIN ( Table1[End] ),
            FILTER (
                ALL ( Table1 ),
                Table1[ClientCode] = MIN ( Table1[ClientCode] )
                    && Table1[TaskId] = 11
            )
        )
            = BLANK (),
        1
    )
)

Best Regards,

Teige

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi

 

How do I go about apply the filter above to my report?

 

TeigeGao