Forum Discussion

filip_u_s's avatar
filip_u_s
Regular Visitor
2 years ago
Solved

Calculation excluding condition

Hi.

I'm a bit rusty and I'm not getting this simple DAX-formula to work.
The formula below is simplified to focus on the problem.
There are two tables, one Core-table and one Data-table and both have an identical ID-column that linkes them both.
However the below formula gives me all values... including the once of the selected "Transportör".

Formula

Förbrukning=
    CALCULATE(
        SUM(Data[Förbrukning]),
        FILTER(Core,Core[Transportör]<>SELECTEDVALUE(Core[Transportör])
    )
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi filip_u_s ,

    If I understand correctly, the issue is that you want to calculate the sum of a column, but including the selected ¨ Transportör ¨. Please try the following method and check if solve the problem:

    1.Create the simple table.

    2.Click on New measure on the Home tab.

     

    3.Enter the following DAX formula. Move the Measure to the table visual.

     

    Measure =
CALCULATE(
    SUM(Data[Förbrukning]),
    NOT Core[Transportör] IN { SELECTEDVALUE(Core[Transportör]) }
)

     

    4.Move the Transportör to the slicer visual.

    5.Select the Transportör and see the Measure. The result excludes the selected Transportör.

     

     

    If the above ones can’t help you get it working, could you please provide more raw data(exclude sensitive data) with Text format and your expected result screenshots? It would be helpful to find out the solution.

     

    Looking forward to your reply.

    Best Regards,

    Wisdom Wu

     

     

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi filip_u_s ,

    If I understand correctly, the issue is that you want to calculate the sum of a column, but including the selected ¨ Transportör ¨. Please try the following method and check if solve the problem:

    1.Create the simple table.

    2.Click on New measure on the Home tab.

     

    3.Enter the following DAX formula. Move the Measure to the table visual.

     

    Measure =
CALCULATE(
    SUM(Data[Förbrukning]),
    NOT Core[Transportör] IN { SELECTEDVALUE(Core[Transportör]) }
)

     

    4.Move the Transportör to the slicer visual.

    5.Select the Transportör and see the Measure. The result excludes the selected Transportör.

     

     

    If the above ones can’t help you get it working, could you please provide more raw data(exclude sensitive data) with Text format and your expected result screenshots? It would be helpful to find out the solution.

     

    Looking forward to your reply.

    Best Regards,

    Wisdom Wu