Forum Discussion

Andy6001's avatar
Andy6001
Frequent Visitor
7 years ago

Renewal rates

Hi, I'm trying to work out customer renewal rates, but the way in which our records are stored is making this tricky with Power BI.   Each customer has a unique User ID, but some customers will ha...
Need Help
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

Andy6001 

 

What is your desired form of result?

 

I mean do you  need

the Count of those users,

or

Names of those users

Do you need it in a Table or a MEASURE?

If you need MEASURES, try these

 

Count_Of_Users =
COUNTROWS (
    FILTER (
        VALUES ( CardTable[User ID] ),
        CALCULATE ( DISTINCTCOUNT ( CardTable[Card ID] ) ) > 1
    )
)

Names_of_users =
CONCATENATEX (
    FILTER (
        VALUES ( CardTable[User ID] ),
        CALCULATE ( DISTINCTCOUNT ( CardTable[Cardstatus] ) ) > 1
    ),
    [User ID],
    UNICHAR ( 10 )
)

 

vbisen's avatar
vbisen
Frequent Visitor
7 years ago

Hi
you can create new measure in the same table (CardTable) 

 

Measure_Name = DISTINCTCOUNT(CardTable[CardStatus])
 
then 
Add Filter for Measure_Name > 1 in your list/table having User ID as single column.. you will get all user ID who have more than 1 record in your table
 
let me know if that's what you wanted