topic SSAS Tabular DAX not interact with a Dimension table in DAX Commands and Tips

SSAS Tabular DAX not interact with a Dimension table

Anonymous — Fri, 17 Apr 2020 13:54:25 GMT

Hello,

I tried to do someting in SSAS tabular model and don't find the solution.

I have a an aggregation : # Leads which I want to return 0 when we select an attribute from a specific dimension table.

is it possible to do this in SSAS or not?

Thanks a lot

Relaach

Re: SSAS Tabular DAX not interact with a Dimension table

Stachu — Sat, 25 Apr 2020 09:44:42 GMT

Almost definitely yes, but your description of the problem is to vague to provide any specific solution.

Can you elaborate about what you want to achieve and include both your input and expected output?

It would be best if you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data. Like this (just copy and paste into the post window).

Column1	Column2
A	1
B	2.5