Forum Discussion
Calculate with filter measure
I have a problem trying to create a measure that would calculate a value based on certain criteria. Model contains four tables: - products (primary) - deals (primary) - sales - pantheon R...
It returns the same value.
SM = MIN(Pantheon[Stage modifier])
primary = CALCULATE(MAX(Products[Primary_classification]),FILTER(Products,Sales[Sales]>0))
I show results in a table that contains id from dimDeals, some measures based on Pantheon columns and a measure based on Sales column