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" 
                                        )
                                )

Victorsam's avatar
Victorsam
Frequent Visitor
3 years ago

Sure ghoshabhijeet .
See photo.
When I use the DAX Anonymous suggested though, I'm only getting sum for [Account Type]"Income"

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi,

I would then check if there are trailing spaces in the Activity and Account Type columns. Any spaces or typos would prevent effective filtering.

  • Victorsam's avatar
    Victorsam
    Frequent Visitor
    3 years ago

    Hi Anonymous 

    Thank you so much. It's working now.