Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I encountered a problem about slicer selection. For simplicity, I have below data for example.
type | app name |
A | app1 |
A | app2 |
A | app3 |
A | app4 |
B | app5 |
B | app6 |
B | app7 |
B | app8 |
B | app9 |
C | app10 |
C | app11 |
C | app12 |
C | app13 |
C | app14 |
I created a slicer with type and a table with appname. What I want to achieve is when I select type A for example, I want the table show from app5 to app14 which belong to type B and C.
Anyone can help me on this?
Thank you.
Regards,
Harry
Solved! Go to Solution.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Thank you. It works on my side.
Hi @Anonymous
To achieve this, you can use something like the following:
Ultimately, you want to create a Table2 that has the "Type" and the "Result" as follows:
Establish the relationship as follows:
Also, when you do not have anything selected, all of your records will be present like below:
Hope this helps 🙂
Theo
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Thanks TheoC. It helps a lot. But my case is the type colume is changing every day, so I cannot manually add results field in. I use concatenatex to sort this out. So Thank you very much.
@Anonymous makes complete sense. Another option that can mitigate the need to manually manipulate is to use SUMMARIZE (dax) or Grouby (Power Query) to automate establish the secondary table and its values. But, in saying that, @CNENFRNL solution is pretty awesome. Only recommendation is, if you want your users to see all records prior to making a selection, just modify the solution a touch.
All the best!
Theo
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |