Row SUM Total of rows made up of Minimum Values

[BugmanJ]

Hi,

In the following table (called "Table"), Each Baker has multiple different ingriendants ('Table'[Cost]) for each of the "Ingriendants" accross the top. The table is set to the minimum value for each. However the ROW total only shows the minimum of that row, I need it to show the SUM of the entire ROW (not column).

Any ideas?

Bonus Questions

1. Taylors has no options for Ingrediant 3, how can this (or other bakers) baker be filtered out if not meeting the number of ingriendants

2. - I actually only want to show the ROW SUM total for each baker, not the column SUM or all the values visible, Is this possible?

Thank you

J

(PS I tried this solution https://community.powerbi.com/t5/Desktop/Grand-Total-of-measure-doesn-t-equal-sum-of-row-values/m-p/... but all it did was to sum all the vairous values!)

[BugmanJ]

Hi @AlexisOlson  / @amitchandak 

I was eventually able to solve this, my example had several tables built together so it was just the right field being referenced.

In addition for the bonus question, I am still struggling. Filtering doesnt work.

Thank you both

[Ashish_Mathur]

Hi,

If your question has not been answered so far, then i'd like to help.  Share the link from where i can download your PBI file.

[AlexisOlson]

You can create a table like this

with a measure like this:

SUMX ( VALUES ( 'Table'[Ingrediant] ), CALCULATE ( MIN ( 'Table'[Cost] ) ) )

If I'm understanding your bonus questions correctly, try this:

IF (
    DISTINCTCOUNT ( 'Table'[Ingrediant] ) = COUNTROWS ( ALLSELECTED ( 'Table'[Ingrediant] ) ),
    SUMX ( VALUES ( 'Table'[Ingrediant] ), CALCULATE ( MIN ( 'Table'[Cost] ) ) )
)

[BugmanJ]

Hi Alexis,

This works until you try and filter the food for any food. it works for all, but as soon as a filter is placed for each different food, it fails. Any thoughts to a solution about that?

Thank you

[BugmanJ]

Hi @AlexisOlson 
Thanks for taking the time to very clearly note all the equations down. Sadly however, I am still stuck with the picture:

What did I do wrong?

[amitchandak]

@BugmanJ , Check if this measure can help

minx(summarize(Table, Table[bakers], Table[Ingredient],"_1", Sum('Table'[Cost])  ), [_1] _

[BugmanJ]

Hi @amitchandak 
Sadly i have the same problem,