sum from table a + filter table b

[Tzachi_Golan]

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 · Accepted solution]

@Tzachi_Golan 

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 🙂

YouTube  LinkedIn

[Tzachi_Golan]

Thanks ! @Fowmy