Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello Team, I have a problem to calculate the Index Price or calculate (divide) al Column_Value/ Select_Product_Value (same column in this case Price).
What is your suggest to Select the produc with Slicer (Producto_Base) and calculate the Index Column (rest of the price products)
Solved! Go to Solution.
Here is one way. Set up the model with a dimension table (recommended) and an independent table for product (you will be using this independent product table for the slicer). The model looks like this:
Set up the table visual using the field from the Product table; the slicer from the 'Select Product' table.
Then these measures:
Price =
DIVIDE(SUM(fTable[Venta]), SUM(fTable[Unidades]))
and
Index =
VAR _Selected =
CALCULATE (
[Price],
FILTER (
ALL ( 'Product Table' ),
'Product Table'[dProducto] = SELECTEDVALUE ( 'Select Product'[Producto Sel] )
)
)
RETURN
DIVIDE ( [Price], _Selected )
and you will get
sample pbix file attached
Proud to be a Super User!
Paul on Linkedin.
WOW Excellent!!!
Rock Star!
Here is one way. Set up the model with a dimension table (recommended) and an independent table for product (you will be using this independent product table for the slicer). The model looks like this:
Set up the table visual using the field from the Product table; the slicer from the 'Select Product' table.
Then these measures:
Price =
DIVIDE(SUM(fTable[Venta]), SUM(fTable[Unidades]))
and
Index =
VAR _Selected =
CALCULATE (
[Price],
FILTER (
ALL ( 'Product Table' ),
'Product Table'[dProducto] = SELECTEDVALUE ( 'Select Product'[Producto Sel] )
)
)
RETURN
DIVIDE ( [Price], _Selected )
and you will get
sample pbix file attached
Proud to be a Super User!
Paul on Linkedin.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
58 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |