Calculate Number of Customers

[simaue]

Hello,

i have a situation on image : 

I need to calculate number of distinct values from first column who have more than 2% of last column, and i want to put this information into new card. I want to see number of 4. 

How to write dax code?

[Fowmy · Accepted solution]

@simaue 

Create a measure as follows:

NewMEASURE =
COUNTROWS (
    FILTER (
        ADDCOLUMNS ( VALUES ( table[Sifra cupca] ), "@m", [iUcescesUprometu] ),
        [@m] > 0.02
    )
)

[Idrissshatila]

Hello @simaue ,

kindly provide a sample data that we can copy so we could provide a solution. also the measure for the percentage column.