POWER BI: Modeling

Calculate Function:

Example Formulas:

Write the following measures in the formula bar:

                   Revenue from All_Regions = CALCULATE(
                              
                               SUM(TransactionData[Revenue]),
                               ALL(TransactionData[Region])
                               )
	        

                     All_Ad_Revenue = CALCULATE(
                                
                                 SUM(TransactionData[Revenue]),
						         ALL(Advertising)
						         )    
	        

                     Total Revenue = CALCULATE(
                                
                                 SUM(TransactionData[Revenue]),
						         ALL(TransactionData)
						         )    
	        

Power BI Demo:

Explanation:

• The revenue column in green is effected by all filters as expected.
• Revenue from All_regions overwrites only one of the slicers. That being the region slicer. Note it is still effected by the state slicer.
• All_Ad_Revenue is overwrites all column slicers assoicated with the advertising table. Those being ad source and ad budget columns.
• Total Revenue returns all the revenue regardless of the slicers applied.