Hi Vilmar,
Thanks for the reply and it worked.
I have implemented similar solution later.
1. Created a measure custom1=IF(SELECTEDVALUE(Sheet1[Product])="Misc",BLANK(),SUM(Sheet1[Sale Amount]))
2. used this measure in the values.
3. unselected show items with no data
This actually hidden Misc product without impacting the complete totals,
Thanks Navya.
------------------------------
Navya K
------------------------------
Original Message:
Sent: Jan 23, 2023 08:58 PM
From: Vilmar Santos
Subject: Hide specific row but it shouldn't impact the totals from the matrix
Veja se esta alternativa ajuda:
- Diminuir a largura da coluna "Product" até ficar zero;
- Criar a medida abaixo:
Products = IF ( SELECTEDVALUE ( Sheet1[Product] ) <> "Misc", SELECTEDVALUE ( Sheet1[Product] ))
PBIX em anexo
------------------------------
Vilmar Santos
Original Message:
Sent: Jan 21, 2023 09:42 PM
From: Navya K
Subject: Hide specific row but it shouldn't impact the totals from the matrix
Hi,
I would like to check if there is a way to hide a specific row from matix but it should impact the subtotals and totals?
In my case I want to hide Misc product from matrix but it should not impact the City, State and Country.
Also, I want to display only subtotals and totals not the values. I wrote the measure to display only subtotals and totals. But wanted to see if I can hide Misc from matrix without impacting totals.
I have attached the pbix file.
Thanks in advance.
------------------------------
Navya K
------------------------------