Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I am connecting using live mode to my cube (SSAS) and wanna apply filter on many column in the same page combining "OR" and "AND" clause, for example:
field1='00' or (field1='11' and field2='ND')
Is there a way to build such report on power bi?
I don't use MDX or DAX Query because I have huge amount of data and power bi not responding anymore.
Thanks
Solved! Go to Solution.
You may add multiple queries in Query Editor.
Based on my experience, here the MDX or DAX query might be necessary.
@v-chuncz-msft Thanks for your answer, I begin to believe too this is the only solution, but how can i import all dimension to analyse data? if i use mdx query, its display just columns in my select, is there a way in power BI to include all dimension based on my query?
You may add multiple queries in Query Editor.
@v-chuncz-msft thanks for your reply, it was very helpful and this is the only solution I found too.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |