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

Hi Anonymous 

The value displayed in your matrix is a count ? 

If yes create this measure 

Otherwise replace "Count('Table'[id])" by "SUM(anything you sum)"

MonthPercentage = DIVIDE(COUNT('Table'[id]),CALCULATE(COUNT('Table'[id]),'Table'[date_inscription]);0)
And then instead of displaying the count display the MonthPercentage measure
Let me know if it works ! 
Regards, Etienne
By the way we can speak in french if you want ;)