Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
i have a data like below screen shot . i want show all multiple divide value in single visual
i am trying to create a measure i am getting error
@THENNA_41 , based on what I got these are three different measures
Truck = divide(SUM('Consumables'[01-Truck Sum of Spend]),SUM('Consumables'[01-Truck Sum of Sum of Shipement Per Quantity]))
STO= divide(sum('Consumables'[02-STO Truck Spend]) , SUM('Consumables'[02-STO Truck Sum of Sum of Shipement Per Quantity]) )
STO1 = divide(sum('Consumables'[02-STO Truck Spend]), SUM('Consumables'[02-STO Truck Sum of Sum of Shipement Per Quantity]))
If not what return statement you want. Var 2 and 3 was having same name
i am getting unexpected expression error like below screen shot
@THENNA_41 , In one measure, try like
measure =
Var Truck = divide(SUM('Consumables'[01-Truck Sum of Spend]),SUM('Consumables'[01-Truck Sum of Sum of Shipement Per Quantity]))
var STO= divide(sum('Consumables'[02-STO Truck Spend]) , SUM('Consumables'[02-STO Truck Sum of Sum of Shipement Per Quantity]) )
var STO1 = divide(sum('Consumables'[02-STO Truck Spend]), SUM('Consumables'[02-STO Truck Sum of Sum of Shipement Per Quantity]))
return
<write the return you want >
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
20 | |
15 | |
10 | |
10 | |
10 |