topic Calculation excluding condition in DAX Commands and Tips

Calculation excluding condition

filip_u_s — Wed, 13 Dec 2023 14:38:46 GMT

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])

)

Re: Calculation excluding condition

Anonymous — Thu, 14 Dec 2023 09:21:06 GMT

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

Re: Calculation excluding condition

filip_u_s — Thu, 14 Dec 2023 10:50:17 GMT

Thanks Wisdom Wu.

That was just what I needed... 🙂