DAX compare data from same table

Question

Hi, new to powerbi, still having a play!&nbsp;I have adhoc snapshots of data, all brought into the same table.&nbsp; This shows three snapshots, but there could be as many as 24 or 36.&nbsp;SS&nbsp; &nbsp; &nbsp;Prod&nbsp; &nbsp;Total100&nbsp; &nbsp;A&nbsp; &nbsp;15100&nbsp; &nbsp;B&nbsp; &nbsp;6100&nbsp; &nbsp;C&nbsp; &nbsp;7101&nbsp; &nbsp;A&nbsp; &nbsp;12101&nbsp; &nbsp;B&nbsp; &nbsp;6101&nbsp; &nbsp;C&nbsp; &nbsp;8102&nbsp; &nbsp;A&nbsp; &nbsp;11102&nbsp; &nbsp;B&nbsp; &nbsp;6102&nbsp; &nbsp;C&nbsp; &nbsp;8&nbsp;I want to have a list where I can choose 101, 102, 103 and have a table which shows&nbsp; &nbsp; &nbsp;101&nbsp; &nbsp; 102&nbsp; &nbsp; VarA&nbsp; 12&nbsp; &nbsp; &nbsp; &nbsp;11&nbsp; &nbsp; &nbsp; -1B&nbsp; &nbsp;6&nbsp; &nbsp; &nbsp; &nbsp; 6&nbsp; &nbsp; &nbsp; &nbsp; 0C&nbsp; &nbsp;8&nbsp; &nbsp; &nbsp; &nbsp; 8&nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp;or&nbsp;&nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; 102&nbsp; &nbsp; VarA&nbsp; 15&nbsp; &nbsp; &nbsp; &nbsp;11&nbsp; &nbsp; &nbsp; -4B&nbsp; &nbsp;6&nbsp; &nbsp; &nbsp; &nbsp; 6&nbsp; &nbsp; &nbsp; &nbsp; 0C&nbsp; &nbsp;7&nbsp; &nbsp; &nbsp; &nbsp; 8&nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp;I've simplied this massively, but basically I want to be able to bring in a colum of information from the data set and compare it side by side.&nbsp;I've created a seperate table which hasSS&nbsp; &nbsp; &nbsp; &nbsp;Index100&nbsp; &nbsp; &nbsp;1101&nbsp; &nbsp; &nbsp;2102&nbsp; &nbsp; &nbsp;3104&nbsp; &nbsp; &nbsp;4Product_total 1 = CALCULATE(SELECTEDVALUE(PRODUCT[product_name]),filter(SNAPSHOT,SNAPSHOT[Index]=1))Product_total 2 = CALCULATE(SELECTEDVALUE(PRODUCT[product_name]),filter(SNAPSHOT,SNAPSHOT[Index]=2))&nbsp;Is there any way to make [index]=Slicer_variable?

anonymous · Accepted Answer

Hi&nbsp;Anonymous,
&nbsp;
You can try to use below formula&nbsp;to calculate&nbsp;difference between selected column items:
Measure =
VAR _min =
    MINX ( VALUES ( Table3[SS] ), [SS] )
VAR _max =
    MAXX ( VALUES ( Table3[SS] ), [SS] )
RETURN
    IF (
        HASONEVALUE ( Table3[SS] ),
        CALCULATE ( SUM ( Table3[Total] ), VALUES ( Table3[Prod] ) ),
        IF (
            COUNTROWS ( VALUES ( Table3[SS] ) ) = 2,
            CALCULATE ( SUM ( Table3[Total] ), Table3[SS] = _min )
                - CALCULATE ( SUM ( Table3[Total] ), Table3[SS] = _max )
        )
    )

&nbsp;
Regards,
Xiaoxin Sheng

Forum Discussion

DAX compare data from same table

2 Replies

Related content

Table Sort , sort order , comparer

Compare 2 Tables

Compare two tables' data in power BI

Compare 2 tables

Comparing Two Sales Tables