Forum Discussion
Custom table with dynamic data
And also to add to the above that the the count should be calculated based on the data within filter and outside filter.
For example:
Category 1 count within filter = 10
Category 2 count within filter = 5
Category 1 count outside filter = 0
Category 2 count outside filter = 0
Total = 15
Apply some filter using slicer
Category 1 count within filter = 7
Category 2 count within filter = 2
Category 1 count outside filter = 3 (10 - 7)
Category 2 count outside filter = 3 (5 - 2)
Total = 15
Thanks
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?