Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Summarise two columns based on time series

Hi Gurus!

 

I am trying to make the below happened but desperate for ideas.

 

Original Data:

 

1.JPG

 

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.

 

2.JPG

 

Does someone happen to know the answer?

 

 

Cheers

Jimmy

1 ACCEPTED SOLUTION

Hi,

You may download my solution file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

10 REPLIES 10
Ashish_Mathur
Super User
Super User

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Sorry I didnt attach the screenshot correctly.

 

3.JPG

Hi,

In the visualisation pane, click on the down arrow of "Count of vendor names" ancd select "Dont Summarize".

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

@Ashish_Mathur  then the this below occurs..

 

4.JPG

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

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.

 

2.JPG

Hi,

You may download my solution file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

It works now! Thank you so much! @Ashish_Mathur 

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

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.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.