Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Double filtering?

Hello All,   I just recently started workign with Power BI/DAX. Via tee help of internet I create below: Budget Cur_Month Cur_Year = CALCULATE( [Budget]; FILTER( 'sales InvoiceItems';RELATED...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    If your tables have relationships as below:

     

    Create a measure in sales InvoiceItems

    measure_budget = SUM('sales InvoiceItems'[budget]) 

    Add this measure in the matrix viusal ad below, along with "year" and "month" columns from "sales Time" table.

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous 

If your tables have relationships as below:

 

Create a measure in sales InvoiceItems

measure_budget = SUM('sales InvoiceItems'[budget]) 

Add this measure in the matrix viusal ad below, along with "year" and "month" columns from "sales Time" table.

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello Maggie, 

 

I will give it a try ans let you know the result