Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello Community,
I have two columns that have the following categories:
| Station | Scene Station |
| 52 | 52 |
| 63 | 63 |
| 61 | 61 |
| 24 | 24 |
| 11 | 11 |
| 103 | 103 |
| Mutual Aid | |
| 12C | |
| blanks | blanks |
When I sum the count distict of my incident ID for each category, I get the following distribution:
I would like to substract the count district of incident ID for 'Station' by count district of incident ID for ' Scene Station', would anyone know how to do this?
Thank you for the help,
Denisse
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 12 | |
| 10 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 31 | |
| 28 | |
| 19 | |
| 11 | |
| 10 |