The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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)
Solved! Go to Solution.
@harry6810 , Try using below measure
Count of Ones =
COUNTROWS(
FILTER(
'YourTableName',
'YourTableName'[Status] = 1
)
)
Proud to be a Super User! |
|
@harry6810 , Try using below measure
Count of Ones =
COUNTROWS(
FILTER(
'YourTableName',
'YourTableName'[Status] = 1
)
)
Proud to be a Super User! |
|
User | Count |
---|---|
25 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
27 | |
12 | |
12 | |
12 | |
6 |