Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone.
I have a spreadsheet that counts how many times a name appears in a listing and also counts how many times a conditional is listed. For example:
A | Yes |
A | Yes |
A | Yes |
B | Yes |
B |
In this case, the expected result is:
A | 3 times |
B | 1 time |
In Excel it's perfect. But I couldn't replicate that in Power BI (I think it was the recent vacation effect).
Solved! Go to Solution.
Hi @LeandroCampacci,
You can use create a table visual with the category field and write a measure formula for counting calculations.
Measure =
CALCULATE (
COUNTA ( Table[Category] ),
FILTER ( ALLSELECTED ( Table ), [Status] = "Yes" ),
VALUES ( Table[Category] )
)
Regards,
Xiaoxin Sheng
Hi @LeandroCampacci,
You can use create a table visual with the category field and write a measure formula for counting calculations.
Measure =
CALCULATE (
COUNTA ( Table[Category] ),
FILTER ( ALLSELECTED ( Table ), [Status] = "Yes" ),
VALUES ( Table[Category] )
)
Regards,
Xiaoxin Sheng
Hi, try
calculate(count([Lettercolumn]),[listing column]="Yes")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |