cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shankarshiva70
Helper III
Helper III

How to count it units>0

Hi guys,

Data is stored in below formats but I have to count at summary 2 level if units>0.

 

Raw data   
CodeUnits  
AP500028621051  
AP50002862105-1  
AP520011608993  
BI800001609436  
    
I have to count at Code level if units>0 
    
CodeUnitsfinal output 
AP5000286210500 
AP5200116089931 
BI8000016094361 
  2 

Please suggest. Thanks a lots.

@Tanushree_Kapse @amitchandak @Greg 

1 ACCEPTED SOLUTION

Hi @shankarshiva70 ,

 

Use these measures:
First calculate the count:

 
Count = Var a= CALCULATE(SUM('Table (3)'[Units]))
return IF(a>0, COUNT('Table (3)'[Code]),0)

second To get the correct total:
Fix = SUMX(VALUES('Table (3)'[Code]),[Count])
 
Tanushree_Kapse_1-1630648767195.png
Mark this as a solution, if I answered your question. Kudos are always appreciated.
Thanks.

View solution in original post

6 REPLIES 6
Tanushree_Kapse
Super User
Super User

Hi @shankarshiva70 ,

 

Please find the Screenshot:

Tanushree_Kapse_0-1630595850872.png

Tanushree_Kapse_1-1630596025237.png

 

Count = VAR a= CALCULATE(COUNT('Table (3)'[Units]),'Table (3)'[Units]> 1)
return IF(a=BLANK(),0,a)
 
 
Mark this as a solution, if I answered your question. Kudos are always appreciated.
Thanks.

 

Thanks for reply.

I have to count >0 units not >1 units.

I have applied the logic already as you mentioned but when I check at code level it is counting where units is 0 as well . like in table 2. first code having units 0 idealy count should not happen at that row.

please check

Hi @shankarshiva70 ,

 

Use these measures:
First calculate the count:

 
Count = Var a= CALCULATE(SUM('Table (3)'[Units]))
return IF(a>0, COUNT('Table (3)'[Code]),0)

second To get the correct total:
Fix = SUMX(VALUES('Table (3)'[Code]),[Count])
 
Tanushree_Kapse_1-1630648767195.png
Mark this as a solution, if I answered your question. Kudos are always appreciated.
Thanks.

Thanks a lot Tanu,

You are super excellent. Salut you. Thank you so much for such a great support.

Always a pleasure!😊

Now I got what I was looking for. 

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors