DAX - PRODUCT() function in Power BI
Product Function -
Returns the product of the numbers in a column.
Syntax – PRODUCT(column)
Parameters –
-- column - The column that contains the numbers for which the product is to be computed.
Return Value – A decimal value.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Ignores blank values by skipping it & multiplies the remaining values.
If all values in the column are blank, PRODUCT returns 1.
PRODUCT does not consider blanks 0, otherwise the result would always be 0.
Create separate specific table for DAX - • Create a measures specific table
Dataset link - https://drive.google.com/drive/folder...