This blog simply introduces how to calculate percentage of total in Matrix with row and column groups from different tables in the model. The key DAX built-in function is ALLEXCEPT. [Read More]

There are many articles about How to pass parameter to SQL statement in PowerBI, but none of them address my issues, so I crack it and decide to write this article to document it. If you have better method, please do let me know! [Read More]

I’ve been struggling to get an Australia Map with Label in Power BI, finally I crack it and I just want to share my experience to you guys. [Read More]