Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |