Need help in writing DAX

hi Shamsbutt ,

Please check following steps as below:

1.    Create measure:

       Measure 2 =

       VAR A =

           CALCULATE ( DISTINCTCOUNT ( 'Dim PI'[Name] ), ALLSELECTED ( Fact_PI ) )

       VAR B =

          MAX ( Fact_PI[PreviousPIsCount] )

       RETURN

           IF (

              ISBLANK ( B ),

              BLANK (),

               IF ( A = 6, 1, IF ( A = 1, 1, IF ( B = 1, BLANK (), 1 ) ) )

       )

2.    Add measure2 to visual filters.

3.    Results would be shown as below:

Pbix as attached, hopefully works for you.

Community Support Team _ Jay Wang

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