Forum Discussion

SAG1's avatar
SAG1
Helper I
9 years ago
Solved

Data Modeling help

Hello All   I am very new to Power BI , Please pardon any mistakes , I have to make couple report 1. All auto dealer , with in selected area (predefined Zip Codes) of one Dealer , Sales . 2. All ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi SAG1,

     

    If below result meets your requirement, you could create two measures like:

     

    AllDealerSales = CALCULATE(SUM(DATATable[VIN]),ALLEXCEPT(DealerTable,DATATable[Make Name]))
SelectedDealerSales = CALCULATE(SUM(DATATable[VIN]),ALLSELECTED(DealerTable[Dealer Name]))

     

    Then, add DATATable[Make Name] and the above two measures into a table visual. 

     

    If I have something misunderstood, please correct me. Please elaborate what does "pass establish relationship between two or not able to pass Seleted Dealer and area as  a parameter to other" mean. What is the relationship? And between which two? And please simplify your source data, take some examples to describe how to calculate "AllDealerSalesinSelectedZip" and "SelectedDealerSalesinselectedZIp".

     

    Regards,
    Yuliana Gu

SAG1's avatar
SAG1
Helper I
9 years ago

Sorry i forgot to provide my DB Structure , this is how it looks (Attached Pic)

 

.

 

I need to make Another report out of it which show 

 

MakeName     AllDealerSalesinSelectedZip       SelectedDealerSalesinselectedZIp

Honda             158                                         82

Acura                160                                        0

 

Any help please !