Countif power Pivot Dax measure

[lavdeepk]

Hi Expert,

I am straggling with power Pivot Dax measure .

Here is my dax code:

(Code calculate distinct customer where [Product Group] = "NP FP PG"  Now i want add new condition measure output should be >0 then count 1 

but  no idea what to do next ??

NPFPPG =
CALCULATE (
    DISTINCTCOUNT ( Collection[CustomerID] ),
    FILTER ( Collection, ( [Product Group] = "NP FP PG" ) )
)

Thanks

Lavdeep

[AlB]

Hi @lavdeepk 

I do not undesrtand the condition you want to add. Can you perhaps provide an example?

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers 

[lavdeepk]

Hi @AlB ,
Sorry for in convince i trying again to explain you.
I have created a measure (code is below) If this measure return output 1 then count 1 if 0 then return 0
i am able to achieve desired output in excel file but straggling in DAX.Refer below SS this may helpful to understand my issue

NPFPPG =
CALCULATE (
    DISTINCTCOUNT ( Collection[CustomerID] ),
    FILTER ( Collection, ( [Product Group] = "NP FP PG" ) )
) 

[AlB]

@lavdeepk 

Try

NPFPPG V2 =
IF( CALCULATE (
    DISTINCTCOUNT ( Collection[CustomerID] ),
    FILTER ( Collection, ( [Product Group] = "NP FP PG" ) )
) > 0, 1,0 )

Please mark the question solved when done and consider giving kudos if posts are helpful.

 Cheers