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 support me on this ?
Thank you in advance for the help 🙂
2 Replies
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) )
Hi,
Share the raw data in a format that can be pasted in an MS Excel file.
