Forum Discussion
Anonymous
1 year agoNot applicable
Matrix Visual Total Only at First Row
Hi Friends, Currently i have created a Matrxi visual using the 3 dimension columns and 1 fact column and the result is below. I am faicng unique situation where i need to show the total on...
- Anonymous1 year ago
Hi Anonymous ,
I created a sample pbix file(see the attachment), please check if that is what you want.
Measure = VAR _category = SELECTEDVALUE ( 'Table'[Product Category] ) VAR _subcategory = SELECTEDVALUE ( 'Table'[Product Sub Category] ) VAR _product = SELECTEDVALUE ( 'Table'[Product Name] ) VAR _minsubcat = CALCULATE ( MIN ( 'Table'[Product Sub Category] ), ALLEXCEPT ( 'Table', 'Table'[Product Category] ) ) VAR _minpro = CALCULATE ( MIN ( 'Table'[Product Name] ), FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Product Category] = _category && 'Table'[Product Sub Category] = _minsubcat ) ) RETURN IF ( _subcategory = _minsubcat && _product = _minpro, CALCULATE ( SUM ( 'Table'[Sales] ), ALLEXCEPT ( 'Table', 'Table'[Product Category] ) ) )Best Regards
Anonymous
1 year agoNot applicable
Hi Anonymous ,
I created a sample pbix file(see the attachment), please check if that is what you want.
Measure =
VAR _category =
SELECTEDVALUE ( 'Table'[Product Category] )
VAR _subcategory =
SELECTEDVALUE ( 'Table'[Product Sub Category] )
VAR _product =
SELECTEDVALUE ( 'Table'[Product Name] )
VAR _minsubcat =
CALCULATE (
MIN ( 'Table'[Product Sub Category] ),
ALLEXCEPT ( 'Table', 'Table'[Product Category] )
)
VAR _minpro =
CALCULATE (
MIN ( 'Table'[Product Name] ),
FILTER (
ALLSELECTED ( 'Table' ),
'Table'[Product Category] = _category
&& 'Table'[Product Sub Category] = _minsubcat
)
)
RETURN
IF (
_subcategory = _minsubcat
&& _product = _minpro,
CALCULATE (
SUM ( 'Table'[Sales] ),
ALLEXCEPT ( 'Table', 'Table'[Product Category] )
)
)
Best Regards