Commercial Dashboard - Revenue Report - Power BI

The Commerical Dashboared Revenue Report is an interactive dashboard where the important key aspects of the business are visualized to make an important decision.

Dashboard Link : https://app.powerbi.com/view?r=eyJrIjoiYmJlMGE2NmItY2U1Ny00MzA5LTlhODktMjAyYjdmMzM4MWRlIiwidCI6ImFmOTE2MGUxLWU1NDUtNDdkOS1hNzQ0LTM3YmZlNzEyNDIwYSIsImMiOjEwfQ%3D%3D

Measures

% Revenue =     
     VAR _Revenue =         
          CALCULATE(            
               [Revenue],            
               ALL(                
                    Fact_Sales            
                    )        
               )            

     RETURN        
          DIVIDE(            
          [Revenue],            
          _Revenue,
          0
          )

Conditoanal Formatting Rev VS Tar =     
     SWITCH(        
     TRUE(),        
     [Revenue] > [Target], 
     "#309429", 
     "#FF0000"    
     )

Customer Count = 
     COUNT(
          Dim_Customer[Customer ID]
     )

No of transaction = 
     COUNT(
          Fact_Sales[Invoice Number]
     )

Quantity = 
     SUM(
          Fact_Sales[Qty Itens]
     )

Rev Vs Tar Max Val x150% = 
     [Target] * 1.5

Revenue = 
     SUM(
     Fact_Sales[Total Price]
     )

SalesPerson Count = 
     COUNT(
          Dim_Resellers[SalesPerson]
     )

Target = 
     SUM(
          Fact_Targets[Target]
     )

Target % = 
     DIVIDE(
          [Revenue],
          [Target],
          0
     )

Target Vs Rev =     
     DIVIDE(        
          [Revenue],        
          [Target],        
          0)

TargetBarColor = 
     DIVIDE(
          [Revenue],
          [Target],
          0
     )

MomthFNmae = 
     FORMAT(
          Dim_Date[Dates], "mmmm"
     )