Forum Discussion

JoseGo's avatar
JoseGo
Frequent Visitor
8 years ago
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:     ...
Need Help
  • Stachu's avatar
    Stachu
    8 years ago

    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

Stachu's avatar
Stachu
Community Champion
8 years ago

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

JoseGo's avatar
JoseGo
Frequent Visitor
8 years ago

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!!! :)