Need help in writing DAX

[Shamsbutt]

Following DAX is fulfilling my basic requirement. But next thing i need to implement is

If multiple pi selected from slicer like PI26 and PI27 then data should be under more than 2PIs Yellow chart means

table should show only those items with PreviousPIsCount > 1

it should not show data with PreviousPIsCount = 1

Here is PBIX file

PICheck = 
IF (
    Fact_PI[PreviousPIsCount] > 1, "More Than 2 PI",
    IF ( Fact_PI[PreviousPIsCount] = 1, "Previous PI", "" )
)

Example:

In case of No Selection or single selection results are fine. Like below image

But in Below image case only more then 2 PIs should show data not in Previous

Thanks

[Anonymous · Accepted solution]

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.

[Shamsbutt]

Help Please