Looking for way to create a measure to display percentage of information from related table.
Hello! I'm a new developer of a Power BI application, which has been going quite well so far, however I have been trying to get something to connect for me. I have a fact table with a list of all transactions at locations which I used countrows for a card to display. This card works well for me because it dynamically changes depending if im selecting one location or all locations. I want to divide this by the amount of customers I have at each location, which is stored in a dimensional table, which is location data (address, customer count). I have tried using a quick measure to divide it by, however it will only give me the amount of locations vs allowing me to dynamically change from all locations or one single location data. Is it possible to relate to this table where I get the specific row to customers to be the denominator for my dynamic fact table? Thank you! Any help is greatly appreciated! -Ceibob