Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Matrix - Calculation inside a matrix

I'm not sure how to explain my request clairly but I will try me best. I have to make this matrix - let's say on a User Table to simplify - On this table I have the subscription date (User[sub_dat...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous ,

    Your "date_inscription is a Date Hierarchy ? If yes can you show me how it's made please ? 

     

    I used measures too, not calculated columns for "Inscrites Valides" and "avec Campagnes", I wanted to have the same model as yours to make something similar, and theyre made like the two you sent me earlier. I just displayed them in the table so its clearer to you. 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Merci beaucoup Etienne Anonymous 

 

I did a measure like this :

 

MonthPercentage = DIVIDE(COUNT('Associations'[id]),CALCULATE(COUNT('Associations'[id]),Associations[date_inscription]),0)

But I got the value of 1... so 100%.

I'm not sur I have explained well my dilemma. If someone need more details about it, tell me please.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Oops sorry Anonymous I forgot the most important : 

Can you try again with this one ? 

MonthPercentage = DIVIDE(
 COUNT('Associations'[id]),
 CALCULATE(COUNT('Associations'[id]),ALLEXPECT(Associations,Associations[date_inscription])),0)

 And if it's not exactly what you needed i guess you'll prefer 

MonthPercentage = DIVIDE(
 COUNT('Associations'[id]),
 CALCULATE(COUNT('Associations'[id]),ALLEXPECT(Associations,Associations[Groupe répartition activation])),0)

Please tell me if i failed again (I hope not)

Regards, Etienne