hide elements in a Pivot Table

[MaJar]

Hi Everyone,

I'm trying to write a dax code that will allow me to hide rows in a pivot table if at least one of the elements is blank: 

Here is an exemple of my request: 

Could you please support me on this ? 

Thank you in advance for the help 🙂 

[Ashish_Mathur]

Hi,

Share the raw data in a format that can be pasted in an MS Excel file.

[amitchandak]

@MaJar ,

Var _qtr = countrows(summarize(All(Date), Date[Qtr]))

var _qtr = calculate( countrows(summarize(fact,Date[Qtr], "_1", Sum(fact[Qunatity]) ), filter(allselected(Fact), Fact[Product] = max(Fact[Product]) )

return

calculate(Sum(fact[Qunatity]), filter(fact, _cnt = _qtr) )