Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance 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 |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
7 | |
6 |