Forum Discussion

Mishelski's avatar
Mishelski
Frequent Visitor
3 years ago

Calculate without select all filter

I have 2 filters on my report, one for the entity and one for the market that the entity interacts with.   In the matrix I have created the 'All Lots' value, in this example the all lots value shou...
Mishelski's avatar
Mishelski
Frequent Visitor
3 years ago

Hi, thats gives me the total lots without factoring in the entire market 

 

What im trying to achieve is where the value will show the total amount of lots for the market id

 

Broker lots = the number of lots the broker has

all lots = the number of lots that market id has, but only if the broker has traded in that market 

 

This is what im trying to achieve but whats happening is the 'select all' part of the market ID filter is including markets that the broker does not trade in, therefore inflating that value to include every market.

 

 

  • DimaMD's avatar
    DimaMD
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hi, Mishelski try it measure

    Value_total = CALCULATE( SUM('table'[value]), ALLEXCEPT('table','table'[market]) )