Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Data comparison from one column / slicer

Hello fellows! I tried to find any possible solution for my problem on the internet, but nothing seems to match my needs.  I have slicer, where different datasets can be chosen:  My hope is t...
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    I created a sample pbix file(see the attachment), please check if that is what you want.

    Qty = 
VAR _minsource =
    MIN ( 'OPI_Database'[Source ID] )
VAR _maxsource =
    MAX ( 'OPI_Database'[Source ID] )
VAR _minqty =
    CALCULATE (
        SUM ( 'QCPW Data'[Quantity] ),
        FILTER ( 'QCPW Data', 'QCPW Data'[Source ID] = _minsource )
    )
VAR _maxqty =
    CALCULATE (
        SUM ( 'QCPW Data'[Quantity] ),
        FILTER ( 'QCPW Data', 'QCPW Data'[Source ID] = _maxsource )
    )
RETURN
    IF (
        ISINSCOPE ( 'OPI_Database'[Source.Name] ),
        SUM ( 'QCPW Data'[Quantity] ),
        _maxqty - _minqty
    )
    SPrice = 
VAR _minsource =
    MIN ( 'OPI_Database'[Source ID] )
VAR _maxsource =
    MAX ( 'OPI_Database'[Source ID] )
VAR _minprice =
    CALCULATE (
        SUM ( 'QCPW Data'[Price] ),
        FILTER ( 'QCPW Data', 'QCPW Data'[Source ID] = _minsource )
    )
VAR _maxprice =
    CALCULATE (
        SUM ( 'QCPW Data'[Price] ),
        FILTER ( 'QCPW Data', 'QCPW Data'[Source ID] = _maxsource )
    )
RETURN
    IF (
        ISINSCOPE ( 'OPI_Database'[Source.Name] ),
        SUM ( 'QCPW Data'[Quantity] ),
        _maxprice - _minprice
    )

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

I created a sample pbix file(see the attachment), please check if that is what you want.

Qty = 
VAR _minsource =
    MIN ( 'OPI_Database'[Source ID] )
VAR _maxsource =
    MAX ( 'OPI_Database'[Source ID] )
VAR _minqty =
    CALCULATE (
        SUM ( 'QCPW Data'[Quantity] ),
        FILTER ( 'QCPW Data', 'QCPW Data'[Source ID] = _minsource )
    )
VAR _maxqty =
    CALCULATE (
        SUM ( 'QCPW Data'[Quantity] ),
        FILTER ( 'QCPW Data', 'QCPW Data'[Source ID] = _maxsource )
    )
RETURN
    IF (
        ISINSCOPE ( 'OPI_Database'[Source.Name] ),
        SUM ( 'QCPW Data'[Quantity] ),
        _maxqty - _minqty
    )
SPrice = 
VAR _minsource =
    MIN ( 'OPI_Database'[Source ID] )
VAR _maxsource =
    MAX ( 'OPI_Database'[Source ID] )
VAR _minprice =
    CALCULATE (
        SUM ( 'QCPW Data'[Price] ),
        FILTER ( 'QCPW Data', 'QCPW Data'[Source ID] = _minsource )
    )
VAR _maxprice =
    CALCULATE (
        SUM ( 'QCPW Data'[Price] ),
        FILTER ( 'QCPW Data', 'QCPW Data'[Source ID] = _maxsource )
    )
RETURN
    IF (
        ISINSCOPE ( 'OPI_Database'[Source.Name] ),
        SUM ( 'QCPW Data'[Quantity] ),
        _maxprice - _minprice
    )

Best Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank you so much! That absolutely worked for me with some minor changes.