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.
Hello all,
Im using the following formulae to count the occurances of the country codes in a field...
USA = CALCULATE ( COUNTROWS (Sheet1),((Sheet1[Citizen]="USA")))
GBP = CALCULATE ( COUNTROWS (Sheet1),((Sheet1[Citizen]="GBP")))
CAN = CALCULATE ( COUNTROWS (Sheet1),((Sheet1[Citizen]="CAN")))
what formulae would I use to count the rows of all of the other values (Not USA, GBP, CAN)
Thanks!
Solved! Go to Solution.
See https://msdn.microsoft.com/en-us/library/ee634237.aspx for all the operators you can use. In this case you could do something like:
OtherValues = CALCULATE((COUNTROWS(Sheet1),(Sheet1[Citizen]<>"USA" && Sheet1[Citizen]<>"GBP" && Sheet1[Citizen]<>"CAN"))
@Anonymous Or since you already have the 3 Measures you can just...
Others = COUNTROWS(Sheet1) - [USA] - [GBP] - [CAN]
EDIT: You probably even have some kind of a TOTAL Measure for ALL countries which you can use instead of COUNTROWS(Sheet1)
See https://msdn.microsoft.com/en-us/library/ee634237.aspx for all the operators you can use. In this case you could do something like:
OtherValues = CALCULATE((COUNTROWS(Sheet1),(Sheet1[Citizen]<>"USA" && Sheet1[Citizen]<>"GBP" && Sheet1[Citizen]<>"CAN"))
Other = CALCULATE( COUNTROWS (Sheet1),
FILTER( Sheet1,
Sheet1[Citizen] <> "USA" && Sheet1[Citizen] <> "GBP" && Sheet1[Citizen] <> "CAN"))
Proud to be a Super User!
You can use below formula:
COUNTROWS(FILTER(Sheet1,Sheet1[Citizen]<>"USA"&&Sheet1[Citizen]<>"GBP"&&Sheet1[Citizen]<>"CAN"))
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |