Forum Discussion
Solved
User select Filter in Calculate
Hello everyone, I have been trying to create a table where it shows different cities and a company's market share in each city. This is an example of the database I am working with: ...
does something like this solve the issue?
Company Share =
VAR SalesCompany = SUM('Table'[Sales])
VAR SalesAllCompanies = CALCULATE(SUM('Table'[Sales]),ALL('Table'[Company]))
RETURN
DIVIDE(SalesCompany,SalesAllCompanies)you can filter the companies with slicer this way
Thank you so, so much, it works perfectly.
I will have to change it a little bit for use in ArcGIS maps, however. With my previous DAX formula the various cities still appeared even if the selected company didn't had any sales (showed general market volume though size but with no color which was was associated with the market share), with this new formula you shared that does not occur, it only shows cities with at least 1 sale.
I am trying to use IF funtions to solve this problem but haven't been successful yet.
Regardless of this thank you very much for your help!!! :)