Forum Discussion
hide elements in a Pivot Table
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...
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) )