Forum Discussion
Custom table with dynamic data
Hi Anonymous,
You may need some measures to achieve such a result. For example, measures could be similar to:
Category 1 count within filter =
CALCULATE (
SUM ( Table[Amount] ),
FILTER ( ALLSELECTED ( Table ), Table[Category] = "Category1" )
)
Category 1 count outside filter =
CALCULATE (
SUM ( Table[Amount] ),
FILTER ( ALL ( Table ), Table[Category] = "Category1" )
)
- [Category 1 count within filter]
For more advice, please provide sample data as suggested in this blog.
Best regards,
Yuliana Gu
Amazing, thats part of the solution, it is giving me the correct counts now. The only other problems are on how to display in the way I mentioned above along with totals. Sorry if this sounds a silly question.
Good that the counts are calculated and showing correct values. I want them to be displayed in rows along with some static values, please see attached image on what i actually need.
The Measures is what i can calculate now, what about the other bits and formation of table with totals and dynamic data?
Thanks for the response so far, much appreciated.
Any help on above?