Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Gurus!
I am trying to make the below happened but desperate for ideas.
Original Data:
Theoretically one company can only have one tax code. So I want to figure out, during this period, how many companies have 2,3,4, or even more tax codes so I can investigate. Below is what I wanted to have ultimately in PBI visual.
Does someone happen to know the answer?
Cheers
Jimmy
Solved! Go to Solution.
Hi,
You may download my solution file from here.
Hope this helps.
Hi,
Why do you not keep it as simple as this. Drag Company to the visual and then write this measure
=DISTINCTCOUNT(Data[Tax code])
Hope this helps.
Sorry I didnt attach the screenshot correctly.
Hi,
In the visualisation pane, click on the down arrow of "Count of vendor names" ancd select "Dont Summarize".
Hope this helps.
Hi,
Drag Vendor name as the first column and apply a filter on >1. You will be able to see which Vendors have more than i tax code.
Hi @Ashish_Mathur ,
I might have confused you but I was wanting more like a summary of "how many" companies have "how many" tax codes instead of having a detailed list of "what companies" have more than tax code, my goal is to have below visual from the data I have.
Hi,
You may download my solution file from here.
Hope this helps.
You are welcome.
Hi @Ashish_Mathur ,
Thank you for your reply, I tried the same thing however it was counting how many types of tax codes in the whole column, just like below.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |