Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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
Solved! Go to Solution.
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 |
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 |
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 9 | |
| 5 | |
| 4 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 23 | |
| 12 | |
| 11 | |
| 9 | |
| 8 |