Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Lets say we have one excel sheet with 3 Columns -
Company | Product | Revenue |
a | 1 | 2300 |
a | 2 | 88 |
b | 3 | 5 |
b | 4 | 94 |
b | 5 | 6 |
c | 3 | 24 |
c | 5 | 14 |
When creating a visual that shows, a table with all three columns and a Product Slicer
When we multi-select product slicer for 3,5 - the expected output should be
Company | Revenue |
b | 11 (6+5) |
c | 38 (24+14) |
@ghadgeomkar , A simple sum should do that
or a measure
sum(Table[Revenue])
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.