Forum Discussion

Victorsam's avatar
Victorsam
Frequent Visitor
3 years ago
Solved

(Blank) on Card

My 'Transactions' table has the following columns; [Account Type], [Account Group], [Account Name], [Year], [Amount], and [Activity]. I have created a measure to get the revenue of an activity. i.e...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi, 

    Have you tried the below?
    Revenue = CALCULATE(
                             Sum( Transactions[Amount]),
                                      FILTER( Transactions, 
                                              Transactions[Account Type] IN {"Income", "Other Income"}
                                               && Transactions[Activity]="Dairy" 
                                        )
                                )

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi, 

Have you tried the below?
Revenue = CALCULATE(
                         Sum( Transactions[Amount]),
                                  FILTER( Transactions, 
                                          Transactions[Account Type] IN {"Income", "Other Income"}
                                           && Transactions[Activity]="Dairy" 
                                    )
                            )

  • Victorsam's avatar
    Victorsam
    Frequent Visitor
    3 years ago

    Hi Anonymous ,
    Thanks for this. The card no longer shows (Blank).
    However, for example, in 2020, the card shows 306,772,172/= as the result. When I check my table, that sum is from [Account Type]"Income" only. 

    Here is a snapshot of my data.