Forum Discussion
Matrix - Calculation inside a matrix
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
So I already try something similar but I don't have the same result as you.
First I cannot have .[Year] or .[Month] on Association[date_inscription] like you do without an error :
Column reference to 'date_inscription' in table 'Associations' cannot be used with a variation 'Year' because it does not have any.
So I had do do something like :
MonthPercentage = DIVIDE( CALCULATE([Avec Campagnes]), CALCULATE([Inscrites Valides], ALLEXCEPT(Associations,Associations[date_inscription])),0)
Also I don't have a calculated columns for "Inscrites Valides" and "avec Campagnes" like you did in your exemple.
It's a measure for both, I'm not sure if that change anything ? It's just a measure that check if there is a certain values inside Associations[state] for "Valides" and a not a BLANK() in Associations[first_campagnes_date] for "avec Campagnes".
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.
Here a sample of my dahboard Anonymous .
Hope I didn't mess up ;)
test.pbix : https://framadrop.org/r/4DAOiaa5t8#tx2oZYocF3TR1PDsz1ID4XvEGzY4oq/z4/aArQLuLTo=On top you have the "classic" matrix and bottom is where I want the % you are trying to help me with.
Left is about campaign, right is about payment.