Forum Discussion
Helper IITreemap with two filters
Hi,
I have created a treemap wich shows the slowest paying company.
Here I have selecter the bottom 10 companies based on their average.
But now I want to add that I only want to see it if the company has bought goods for a certain amount in total.
Now it's looking at all companies and the top-10 is all based on companies that have only put in one order.
How can I add this second part?
I made a new colomn in the clients table where it shows me the total revenue for each client.
This I can use in a slicer.
Total revenue = CALCULATE(SUM(DEBFACTUUR[FACTBEDRAG]);FILTER(DEBFACTUUR;DEBFACTUUR[CDDEBITEUR] = REL_DEB[CDDEBITEUR]))Revenue 2019 = CALCULATE(SUM(DEBFACTUUR[FACTBEDRAG]);FILTER(DEBFACTUUR;DEBFACTUUR[CDDEBITEUR] = REL_DEB[CDDEBITEUR]);FILTER(DEBFACTUUR;DEBFACTUUR[BOEKJAAR] = 2019))
3 Replies
Wiene24But I want it based on the revenue.
I have a measure: Total revenue = CALCULATE(SUM(DEBFACTUUR[FACTBEDRAG]))
In a table etc this works, because it devides it over the costumors. If I add this to the Treemap it will only look at the total of a single invoice.
I can't use calculated colomn because I use year filters and the visual should change with it.
I can't use a slicer with the measure either, it just doesn't allow it.
- Wiene24
I made a new colomn in the clients table where it shows me the total revenue for each client.
This I can use in a slicer.
Total revenue = CALCULATE(SUM(DEBFACTUUR[FACTBEDRAG]);FILTER(DEBFACTUUR;DEBFACTUUR[CDDEBITEUR] = REL_DEB[CDDEBITEUR]))Revenue 2019 = CALCULATE(SUM(DEBFACTUUR[FACTBEDRAG]);FILTER(DEBFACTUUR;DEBFACTUUR[CDDEBITEUR] = REL_DEB[CDDEBITEUR]);FILTER(DEBFACTUUR;DEBFACTUUR[BOEKJAAR] = 2019))
