Forum Discussion
Solved
Calculate Variance Between Two Columns in Matrix Visual
I have two fact tables: f_scripts and f_rebates. Each has a quantity column showing sum of units by date (I also have them linked to a calendar table). I'm trying to create a matrix visual showing th...
HI mcmullenrich,
What type of aggregate that you want to apply to these grouped ranges of records? Can you please share some more detail?
How to Get Your Question Answered Quickly
Here is a sample measure formaul about average of records based on current hierarchy group.
formula = CALCULATE ( AVERAGE ( Table[Purchased] ), ALLSELECTED ( Table ), VALUES ( Table[Common Drag Name] ), VALUES ( Table[Pharmacy] ) )Regards,
Xiaoxin Sheng
Hi, mcmullenrich
If you could share some sample data or help me picture how exactly the delta should be shown (absolute, relative etc.)
Thank you