Forum Discussion

jldaley86's avatar
jldaley86
Advocate II
9 years ago
Solved

Showing non-selected data from same table

Hey Everyone :)   I have what should be a straight forward request but am unable to figure out how it can be done. Essentially I want to filter on a record so we can show off all the information re...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi jldaley86,

     

    According to your description above, you should be able to CALCULATE with ALL to get your expected result. The formula below is for your reference. :smileyhappy:

    Total Amount for others =
CALCULATE (
    SUM ( 'Table1'[Amount] ),
    FILTER (
        ALL ( 'Table1' ),
        'Table1'[InvoiceNo] = FIRSTNONBLANK ( 'Table1'[InvoiceNo], 1 )
            && 'Table1'[Month] < MAX ( 'Table1'[Month] )
    )
)

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi jldaley86,

 

According to your description above, you should be able to CALCULATE with ALL to get your expected result. The formula below is for your reference. :smileyhappy:

Total Amount for others =
CALCULATE (
    SUM ( 'Table1'[Amount] ),
    FILTER (
        ALL ( 'Table1' ),
        'Table1'[InvoiceNo] = FIRSTNONBLANK ( 'Table1'[InvoiceNo], 1 )
            && 'Table1'[Month] < MAX ( 'Table1'[Month] )
    )
)

 

Regards