a dax evaluate that sums in ssms with a filter

[db042190]

Hi I couldnt figure this one out today.  I'd like to run a combo of these 2 things returning the value in ssms rather than assigning it to a column as a calc.   The idea is to verify independently of pbi what values i'm getting in pbi reporting.

part 1: Evaluate ("row sum",sum('sales'[revenue]))

part 2:  Filter ('sales',related('bizunit'[bkey])=1234 && ...&&...)

[db042190]

thx, i can make it simpler.  I'm in ssms and told ssms i'm writing a new dax query.  My tabular table called sales has a column called revenue in it.  I'd like the sum of revenue from sales with a restriction on a related table called bizunit  and a restriction on invoicedate in the sales table.   the restriction on related table bizunit is that its column called bkey = 1234.  and the restriction on invoicedate in sales be that it be for all of novermber 2023.

[Anonymous]

Hi @db042190 ,

Please try to create measure with below dax formula:

Measure=sum('sales'[revenue])

Meaure 2=calculate([Measure],'bizunit'[bkey])=1234,'sales'[invoicedate]=2023/11)

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[db042190]

i dont know if you understand.  I want to select it in ssms, not assign it to a measure unless measures you calculate in ssms can be selected in ssms.   and i was hoping to do it in one step.  

[Anonymous]

Hi @db042190 ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu