Power Platform

Every organization must protect its data while ensuring that the right people have access when they need it. Microsoft Power Platform offers a feature called hierarchy security , which makes controlling access easier and more precise, even in complex environments. In this guide, we'll walk you through the basics in plain language. What Is Hierarchy Security? Hierarchy security is an extension of existing security models in Power Platform (like business units, security roles, sharing, and teams). It helps you define who can see what data by building a logical structure based on a company's management or job roles. Essentially, it lets you assign access rights using a "chain of command" or a "position" setup. This method is not only more granular (or detailed) but also reduces the effort required to manage many business units manually. The Two Key Models There are two common ways to organize hierarchy security: 1. Manager Hierarchy The manager hierarchy is ba...

Power BI offers powerful DAX functions, and RANKX is one of the most useful when you want to assign ranks based on measures like sales, profit, or quantity. But if you're new to it, it might not work as expected at first. In this blog, I'll walk you through a real-world scenario where I explored RANKX, faced common issues, and how I solved them. Syntax of RANKX RANKX(     table,     expression,     [value],     [order],     [ties] ) Parameter Description table The list (table or column) over which ranking is done. expression The expression to evaluate for each row (usually a measure like [total sale]). Value(optional) A value to rank (rarely used; DAX infers automatically). order(optional) ASC (ascending) or desc (descending). Default is asc ties(optional) How to handle ties: skip, Dense  or leave blank (default is Skip ). our goal is we want to calculate a rank for products based on total sales usi...