Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 Auto dealer Sales by Make (like Honda), with in selected area (predefined Zip Codes) of one Dealer , Plus Sales by Make for selected Dealer .
I am able to do First (attached Pics) , But not second requirement , as i am not able to pass establish relationship between two or not able to pass Seleted Dealer and area as a parameter to other .
Can somebody shade any light on it .
Greatly Appriciated .
Solved! Go to Solution.
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
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
Thank You buddy ! it did work with two measures , i had to add additional filter in measure formula but it worked .
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 !
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |