Forum Discussion

Shamsbutt's avatar
Shamsbutt
Icon for Helper II rankHelper II
6 years ago
Solved

Need help in writing DAX

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

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.