POWER BI: Modeling

Calculate Function:

Example Formulas:

Write the following measures in the formula bar:

                     % of Large Transactions By Ad Source = DIVIDE(
                     
	                CALCULATE(SUM(TransactionData[Revenue]),TransactionData[Revenue] > 10000),
	                CALCULATE(SUM(TransactionData[Revenue]),TransactionData[Revenue] > 10000, ALL(Advertising[Ad Source])),
	                0) 
	               

Power BI Demo:

Explanation:

Shows how to combine three important functions in DAX using one expression. This works because with the ALL function the denominator is not effected by the filter.