Forum Discussion
SSAS Tabular DAX not interact with a Dimension table
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
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
1 Reply
- Stachu
Community Champion
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