Forum Discussion

xv's avatar
xv
Frequent Visitor
10 years ago

Aggregate multiple measures from selecting multiple values of a slicer

Hi, thanks in advance for any help with this situation. We need to calculate the sum (aggregation) of selecting multiples values of a slicer (when each slicer item represent a sum of a column of a ta...
Need Help
Tips and Tricks
Tutorial Requests
Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

xv

 

Try a measure as below.

 

Measure =
IF (
    ISFILTERED ( disconected_table_name[item] ),
    SUMX (
        FILTER (
            ALL(Table1),
            CONTAINS (
                VALUES ( disconected_table_name[item] ),
                disconected_table_name[item], Table1[item]
            )
        ),
        Table1[amt]
    ),
    0
)

 

By the way, why not create a proper relationship between those two tables?

  • Eric_Zhang's avatar
    Eric_Zhang
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    xv

     

    xv wrote:

    Ty Eric for your time. Your solution is quiet right, but my problem is that table1 represent a table where each item is a columnof another table. 

     

    What i need is the same as this example (http://breaking-bi.blogspot.cl/2016/06/power-bipowerpivot-using-slicers-to.html), but whent i click in more than 1 slicer item, get the sum.

    What do you mean "item is a column of another table", could you provide a sample pbix?