Forum Discussion

Miguel05's avatar
Miguel05
Regular Visitor
5 years ago
Solved

DAX Measure which Filter values from Table

Hi all! I am trying to achieve two measures which give me the following: The total Amount Invoiced of Projects which have an Amount Invoiced greater than 100K. A count of projects which hav...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Please try this measure expression

     

    Invoiced Over 100k =
    VAR vSummary =
        SUMMARIZE (
            'Project Transactions',
            'Project Transactions'[Project Name],
            "cInvoiced", SUM ( 'Project Transactions'[Amount Invoided] )
        )
    RETURN
        SUMX (
            FILTER (
                vSummary,
                [cInvoiced] >= 100000
            ),
            [cInvoiced]
        )

     

    For your count measure, just change the Return to COUNTROWS(FILTER(vSummary, [cInvoiced] >=100000))

     

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

Please try this measure expression

 

Invoiced Over 100k =
VAR vSummary =
    SUMMARIZE (
        'Project Transactions',
        'Project Transactions'[Project Name],
        "cInvoiced", SUM ( 'Project Transactions'[Amount Invoided] )
    )
RETURN
    SUMX (
        FILTER (
            vSummary,
            [cInvoiced] >= 100000
        ),
        [cInvoiced]
    )

 

For your count measure, just change the Return to COUNTROWS(FILTER(vSummary, [cInvoiced] >=100000))

 

Regards,

Pat