topic Re: sum from table a + filter table b in DAX Commands and Tips

sum from table a + filter table b

Anonymous — Sun, 29 Nov 2020 10:35:37 GMT

hey ,

maybe uts simple in DAX but i'm new at this :

how can I sum a column from table A and filter the results where a coulmn from table B is not blank

thanks for the help

Fowmy — Sun, 29 Nov 2020 12:44:01 GMT

Anonymous

Providing sample data and describing the model and relationship would be ideal to get the answer quickly. Please try the following.

Measure = Calculate(sum(TableA[Column]), TableB[Column] <> Blank() )

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

Anonymous — Sun, 29 Nov 2020 12:46:23 GMT

Thanks ! Fowmy