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
qinny
Frequent Visitor

Sales by members & Non members

hi all, I am new to power bi, hope someone can advice on the following:

 

I have a worksheet of transactions made by members & non members, and sales amount.

member has a ID no. and nonmembers are indicated by NIL

 

How can i write a formula for sales made by members & non members?

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

 

In a simple Table visual, drag ID column and write the following measure

 

=SUM(Data[Amount])

 

Hope this helps.


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

View solution in original post

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

 

In a simple Table visual, drag ID column and write the following measure

 

=SUM(Data[Amount])

 

Hope this helps.


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

One way would be:

 

Sales of members = CALCULATE (SUM(TableName[Sales], TableName[ID] <> BLANK())

 

Sales of non-members = CALCULATE(SUM(TableName[Sales], TableName[ID] = BLANK())

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.