Forum Discussion

Bobass75's avatar
Bobass75
Frequent Visitor
1 year ago
Solved

How to fix range measure calculation

The goal for the measure is to calculate sales value ranges based on OPA_ID in the current context. Range < 150k Sales Invoices Amount = VAR FilteredOPA =     FILTER (                ADDCOLUM...
FBergamaschi's avatar
FBergamaschi
Icon for Super User rankSuper User
1 year ago

Hoping to have understood what yo uare willing to get

 

Range < 150k Sales Invoices Amount =

VAR FilteredOPA =

    FILTER (

               ADDCOLUMNS (

                SUMMARIZE ( 'Fact Sales Invoices', 'Dimension Opportunity Attributes'[OPA ID] ),

                "Sales", 'Fact Sales Invoices'[Sales Invoices Amount NOK]                      

            )

        ,

        [Sales] < 150000

    )

VAR selected =

    SELECTCOLUMNS ( FilteredOPA, 'Dimension Opportunity Attributes'[OPA ID] )

 

VAR Table_with_lineage =

    TREATAS ( selected, 'Dimension Opportunity Attributes'[OPA ID] )

 

RETURN

    CALCULATE ( 'Fact Sales Invoices'[Sales Invoices Amount], Table_with_lineage, REMOVEFILTERS ( Product[ProductNo] )

 

If this helped, please consider giving kudos and mark as a solution

me in replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI