Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hello,
I am trying to create a calculated field to show market share. I get the field, however when I put it as a visual, I only have choices to average, sum, median, variance, etc. I just want to see the market share by selected filters. I'd imagine this has to be possible and I'm just missing something. I appreciate any advice.
Thanks
Hi @csteves,
The calculated field just acts as the normal fields. For example below, if you select item A, the calculated column should perform an aggregation calculation.
Item Calculated_column
A 10
A 20
Maybe you need a measure. Please share a dummy sample.
Best Regards,
Dale
| User | Count |
|---|---|
| 23 | |
| 21 | |
| 20 | |
| 17 | |
| 11 |
| User | Count |
|---|---|
| 54 | |
| 53 | |
| 40 | |
| 37 | |
| 32 |