DAX

Dynamic Row Level Security in Power BI

Interested in learning how to set up row level security (RLS) in Power BI when you have varied criteria? In this post I’ll walk through a scenario of setting up dynamic row level security in which your users have unique access needs. In other words, one user has access to the Northeast and Midwest regions, another has access to the Southeast, and two others overlap with access to the South and Northwest regions.

Steve WiseDynamic Row Level Security in Power BI
Read More

My List of Top Contributors in the Data/BI Community

As I read the many posts from those in the community who I follow, I am reminded that the community brain trust is much greater than any individual. As a writer and blogger, I’m occasionally compelled to express an original thought or opinion that I think is uniquely my own. However, we work in a world where everything comes from somewhere and there are many contributors who I trust and rely upon for advice and cutting-edge information. This “corner” of my blog is to highlight these community contributions that I find informative.

Paul TurleyMy List of Top Contributors in the Data/BI Community
Read More

Azure Data Week – Intro to DAX in Power BI

BannerFinal Azure Data Week

During Azure Data Week, Mike Davis showed us some of the basics on Power BI and DAX. There were many questions he was unable to answer during his session and we’re happy to share them with you now. If you missed Mike’s session or the entire week, you can still purchase access to the recordings by visiting azuredataweek.com

Tom WardAzure Data Week – Intro to DAX in Power BI
Read More

Understanding DAX Filter Context and Incorrect Totals

MitchP BannnerDAX is an awesome language, but sometimes, DAX can produce results that are not expected. This is when DAX users can begin to struggle and get frustrated with the DAX language. In a recent webinar titled, Understanding DAX Filter Context and Incorrect Totals, our host Mitchell Pearson will walk you through why the total is not working, what’s happening with the filter context and how you can dig into that and figure out what that filter context is.

Tom WardUnderstanding DAX Filter Context and Incorrect Totals
Read More

Introduction to DAX

free training with Nick LeeAre you looking to get an introduction to DAX and learn more about this powerful tool? In a recent webinar, hosted by Nick Lee, you will be introduced to the basics using the DAX language to create calculated columns and calculated measures. In addition to the basics, this session will introduce you to creating aggregates, conditional functions, and time intelligence calculations.

Tom WardIntroduction to DAX
Read More

Power BI – Problem, Design, Solution – Text Search Slicer

In this installment of the “Problem, Design, Solution” series, we are going to walk through the process of performing a text search using slicers in Power BI, simulating a “LIKE” type search. Please note that there is a video explaining the solution in-depth at the end of the blog under “Resources.”

Tom WardPower BI – Problem, Design, Solution – Text Search Slicer
Read More