Forum Discussion

Aaronjoem's avatar
Aaronjoem
Frequent Visitor
7 years ago
Solved

DAX - Search & Find question - post per Ruth (youtube)

Issue - Trying to sum (amount) with the following filters. What I have so far if you were doing it in excel the normal way 1. Calculate (Amount) - easy 2. Filter column (A) on the word Actual (easy)...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Aaronjoem ,

    Maybe you can try to use following measure formula if it suitable for your requirement:

    formula =
CALCULATE (
    [Total Resource Amount],
    FILTER (
        ALLSELECTED ( OneLink_Report ),
        OneLink_Report[Ledger] = "ACTUALS"
            && LEFT ( OneLink_Report[Child Activity], 2 ) = "27"
            && LEN ( OneLink_Report[Child Activity] ) = 6
    )
)

    Regards,

    Xiaoxin Sheng

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

Hi Aaronjoem 

Try this:

 

Measure =
CALCULATE (
    SUM ( Table1[Amount] );
    Table1[ColumnA] = "Actual";
    INT ( DIVIDE ( Table1[ColumnB]; 10000 ) ) = 27
)