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.
Hi all,
Here is a trick question and hope someone can help. Two tables: Client and ICD as below screenshot. I was able to create measures and count client for a single selection, such as if I select A01 in slicer, I will have client count 2, and B01 gets 3.
Solved! Go to Solution.
Hi,
You may download my solution file from here.
Hope this helps.
Thanks for your reply Ashish. I will give it a try and see how it goes. For the real dataset, there will be around 50M rows of records, with ICD, and other codes concatenate together for mulitple columns, if we create scalar values for each ICD and other columns, there will be probably 500M records or even more if considering the combinations. This is the reason why we started without creating any relationship and put all the ICD string together. Best,
Hi,
You may download my solution file from here.
Hope this helps.
Hi Ashish,
is it possible for you the repeat the solution sharing?
I do not have the file. Share some data to work with, explain the question and show the expected result.
Hi Ashish, I have a multi-select slicer (named Clients) that I want to use for filtering the table rows acting on the Customers column.
For example, looking at the image, the selected rows should be the ones pointed.
Thanks for your support.
Sarah
Hi,
I am not sure how much i can help but i'd like to try. Share the download link of the PBI file.
Hi,
I cannot share the PBI file because contains sensible data.
I try to post my question as a new topic hoping someone had the same issue.
Thanks for you attention!
Hi Ashish, Thank you very much, could you please post the dax measure? For whatever reason, my 2020 Dec version is unable to open your file. Appreciate your help.
Hi,
The DAX measure is a simple DISTINCTCOUNT() function. What's important is the transformation which i used in the Query Editor.
User | Count |
---|---|
80 | |
74 | |
41 | |
30 | |
28 |
User | Count |
---|---|
107 | |
96 | |
53 | |
47 | |
47 |