Forum Discussion
Create a calc column DAX formula for a specific need
HI all - You have all been so helpful! Love this forum! I am very new to PBI. Loving it! I need to create a calculated column in a table I am working with. One column is a BILL TO c...
vanessafvg
Community Champion
Community Championare you wanting to filter by those outlets?
then you would use a filter function
ie
https://forum.enterprisedna.co/t/writing-a-dax-function-to-filter-out-multiple-criteria-for-a-given-product/4421
Filtered Total Sales =
CALCULATE(
[Total Sales],
FILTER(
Outlet,
OutletName = "insertnamehere" ||
OutletName = "insertnamehere" ||
OutletName = "insertnamehere" )
)
|| = or
then you would use a filter function
ie
https://forum.enterprisedna.co/t/writing-a-dax-function-to-filter-out-multiple-criteria-for-a-given-product/4421
Filtered Total Sales =
CALCULATE(
[Total Sales],
FILTER(
Outlet,
OutletName = "insertnamehere" ||
OutletName = "insertnamehere" ||
OutletName = "insertnamehere" )
)
|| = or