Forum Discussion
BrendaB
2 years agoFrequent Visitor
Adding Rows Together in Matrix to be Used in a Measure
I am not sure how to even explain without just showing you my issue...ha! I have 5 rows that make up revenue, and I need to add them together so that I can use that total to calculate the % of r...
- 2 years ago
BrendaB , The below one should use allselected or all
like a new measure
calculate([$/Revenue], allselected())
Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s
amitchandak
2 years agoSuper User
BrendaB , The below one should use allselected or all
like a new measure
calculate([$/Revenue], allselected())
Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s
- BrendaB2 years agoFrequent Visitor
This worked! I appreciate the help! Definitely subscribing to your channel, easy to understand!