Forum Discussion

Ghoghnuse2's avatar
Ghoghnuse2
New Member
1 year ago
Solved

How to Compare Different Production Versions in Power BI Using Slicers

  Hello,   I have a table that contains various production versions, such as 2024-01-AC, indicating production in January 2024, Actual version. All these versions are appended together and sep...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Ghoghnuse2 ,

    Based on the description, copy data to another table. If two slicer values come from the same table, they will interact with each other. Try using the following DAX formula.

    Avg Cost Ver1 = CALCULATE(
    AVERAGE('Table'[AVG Cost]),
    FILTER('Table', 'Table'[Ver] = [Selected Ver1])
)
    Avg Cost Ver2 = CALCULATE(
    AVERAGE('Table copy'[AVG Cost]),
    FILTER('Table copy', 'Table copy'[Ver] = [Selected Ver2])
)

     

    Best Regards,

    Wisdom Wu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Ghoghnuse2 ,

Based on the description, copy data to another table. If two slicer values come from the same table, they will interact with each other. Try using the following DAX formula.

Avg Cost Ver1 = CALCULATE(
    AVERAGE('Table'[AVG Cost]),
    FILTER('Table', 'Table'[Ver] = [Selected Ver1])
)
Avg Cost Ver2 = CALCULATE(
    AVERAGE('Table copy'[AVG Cost]),
    FILTER('Table copy', 'Table copy'[Ver] = [Selected Ver2])
)

 

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.