Forum Discussion
Anonymous
6 years agoNot applicable
User customizable Pivot Table
Hi, I have a requirement in my Power BI report that I'm struggling with for days now. My datamodel is quite large with > 20 tables. I would like a matrix where I can count the distinct amount...
- Anonymous6 years ago
The new preview feature 'personalize visual experience' is the solution for me. Thank you for your help.
Regards,
Tiemen
amitchandak
6 years agoSuper User
Anonymous , use all expect
https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/
This should give you the required data
Anonymous
6 years agoNot applicable
Hi amitchandak ,
Thanks for your reply. Personally I do not the relation between creating a customizable pivot table in Power BI for browser based users and using ALLEXCEPT in DAX. Can you explain how ALLEXCEPT can help me in creating the customizable pivot table?
Regards,
Tiemen