This content has been marked as final. Show 1 reply
Typically, no, this is not something you can do, but there are some potential ways to get around it depending on your specific use case:
- (Unlikely) If you are using an OLAP (cube) data source, you can write a calculated member that groups other members and allows you to see everything side-by-side
- You can create a separate measure for each dimension value. E.g. a measure named Apartment Count with code IF Dimension == 'Apartment' THEN 1 ELSE 0 END and then one for Condo Count and another for Apartment and Condo Count. Then using Measure Names/Measure Values you can construct a view that shows all the counts (or another measurement by replacing the 1)
- (Messy) You can restructure your data (via union or some kind of join) that would give you two records for everything and then count one of them for one dimension and then the other for another dimension.
Hope that helps!