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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
harry6810
Frequent Visitor

Calculate Measure with IF Statement

Hi,

I'd like to create a measure that counts all the occurrences of "1" in a table (column "Status"). This will be used to visualize the data in a chart.

Current Measures:

- eLen price = CALCULATE(Min('CEN'[Price]),CEN[Reseller]="eLen ")
- Min price = MIN(CEN[Price])
- Status = IF([eLen price] = [Min price],1,0)

 

harry6810_0-1718884108091.png

 

1 ACCEPTED SOLUTION
bhanu_gautam
Super User
Super User

@harry6810 , Try using below measure

 

Count of Ones =
COUNTROWS(
FILTER(
'YourTableName',
'YourTableName'[Status] = 1
)
)




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






View solution in original post

1 REPLY 1
bhanu_gautam
Super User
Super User

@harry6810 , Try using below measure

 

Count of Ones =
COUNTROWS(
FILTER(
'YourTableName',
'YourTableName'[Status] = 1
)
)




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.