Forum Discussion
Wiene24
Helper II
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 th...
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))
Wiene24Helper II
Helper IIBut 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.
Wiene24Helper II
Helper III 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))