Forum Discussion
User select Filter in Calculate
- 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
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!!! :)