Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Add Sumif values from a different table based on slicer selection

Hi,   I would like to fulfil a column with a sumif of values from a different table but with a filter from a slicer.   Let’s give the example: One table has a list of items with two columns (it...
Need Help
  • Dinesh_Suranga's avatar
    Dinesh_Suranga
    3 years ago

    Anonymous 

    Hi,

    Right click the Item then tick show items with no data.

    Please accept this as solution if this helped to solve your problem.

    Thank you

     

Dinesh_Suranga's avatar
Dinesh_Suranga
Continued Contributor
3 years ago

Anonymous 

First -  Create relationship between items table and consumption table base on Item.

 

Then create a mesure using  following DAX formula.

Consumption = SUM(Consumptions[qtd])

Then you will get the answer.

Please post back here if you are having issues.

If this post helped to solve your issue. Please acept as the solution.

Thank you.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Dinesh,

 

Thanks, but I need keep the other items in the list with zero values.

 

Many Thanks

Nuno Paixão

 

  • Dinesh_Suranga's avatar
    Dinesh_Suranga
    Continued Contributor
    3 years ago

    Anonymous 

    Hi,

    Right click the Item then tick show items with no data.

    Please accept this as solution if this helped to solve your problem.

    Thank you