The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
34 | |
15 | |
12 | |
7 | |
6 |