Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Release filter by drill down level

Hello,   I'm trying to show accounting data to the user with PowerBI. The user needs to see trail from the account to the journal entry.   Level 1 is the Accounts and their sum.   Level 2 is th...
Need Help
  • BhaveshPatel's avatar
    BhaveshPatel
    10 years ago

    You should write the meaure such as this.

     

    Measure1:=CALCULATE(SUM[AMOUNT]),ALL(Table[Accounts])

    Measure2:=CALCULATE(SUM[AMOUNT]), Table[Accounts]="1030")

    Measure3:=CALCULATE(SUM[AMOUNT]),ALL(Table[Journals]

     

    And Drag and drop them around and it would solve your problem.

BhaveshPatel's avatar
BhaveshPatel
Super User
10 years ago

You should write the meaure such as this.

 

Measure1:=CALCULATE(SUM[AMOUNT]),ALL(Table[Accounts])

Measure2:=CALCULATE(SUM[AMOUNT]), Table[Accounts]="1030")

Measure3:=CALCULATE(SUM[AMOUNT]),ALL(Table[Journals]

 

And Drag and drop them around and it would solve your problem.