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
Mahadevaraobc
Helper II
Helper II

Sum of SubCategory

Hi, I have the following issue Please help,

 

I have a table with Month, Column A  and Column B

 

How do i get Column Total and sum that based on month.

 

1 ACCEPTED SOLUTION

@Mahadevaraobc

 

I am not sure if I understand your scenairo correclty.

 

You can use count. If you don't want to count duplicated the parts. You caan use distinctcount

 

Measure = COUNT(Sheet1[B])
 
Measure = DISTINCTCOUNT(Sheet1[B])
 
c1.JPGc2.JPG




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

6 REPLIES 6
v-yulgu-msft
Employee
Employee

Hi @Mahadevaraobc,

 

You could create some dummy data like what ryan_mayu did to illustrate your requirement.

How to Get Your Question Answered Quickly

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ryan_mayu
Super User
Super User

@Mahadevaraobc

 

I think you can just use sum formula. Could you please explain what situation you are in?

 

Measure = sum(Table3[Column1])

 

 

 

c1.JPGc2.JPG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Thank You,

 

I have some data in Column B, which is subcategory of column A, how can i count many are present and sum the value and show that for month.

@Mahadevaraobc

 

Could you please provide more info and elaborate it? It's better to provide some sample data and the result you expected.Thanks.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Hi,
As I don't have sample data let me elaborate the issue
I have month column, column A ( serial no) and column B (part)
Eg . Column A has 10 serial numbers and assuming each serial no has multiple no parts in column B
Now how do I show in a month how many parts were sent for 1 serial number

@Mahadevaraobc

 

I am not sure if I understand your scenairo correclty.

 

You can use count. If you don't want to count duplicated the parts. You caan use distinctcount

 

Measure = COUNT(Sheet1[B])
 
Measure = DISTINCTCOUNT(Sheet1[B])
 
c1.JPGc2.JPG




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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.