lizzyHelper I5 years agoSolvedDynamic Weighted Sum I'm trying to create a dynamic weighted sum of different attributies of categories to get a total using user-adjustable parameters. My component table looks something like this: Categories Valu...Show MoreFowmy5 years agolizzy You can try this meaure: Output = IF ( HASONEVALUE ( table[Categories] ), SUM ( table[value1] ) * SELECTEDVALUE ( 'Parameter1'[value] ) + SUM ( table[value2] ) * SELECTEDVALUE ( 'Parameter2'[value] ) )
Fowmy5 years agolizzy You can try this meaure: Output = IF ( HASONEVALUE ( table[Categories] ), SUM ( table[value1] ) * SELECTEDVALUE ( 'Parameter1'[value] ) + SUM ( table[value2] ) * SELECTEDVALUE ( 'Parameter2'[value] ) )
Fowmy5 years agolizzy You can try this meaure: Output = IF ( HASONEVALUE ( table[Categories] ), SUM ( table[value1] ) * SELECTEDVALUE ( 'Parameter1'[value] ) + SUM ( table[value2] ) * SELECTEDVALUE ( 'Parameter2'[value] ) )
FowmySuper User5 years agolizzy You can try this meaure: Output = IF ( HASONEVALUE ( table[Categories] ), SUM ( table[value1] ) * SELECTEDVALUE ( 'Parameter1'[value] ) + SUM ( table[value2] ) * SELECTEDVALUE ( 'Parameter2'[value] ) )
Related contentPower BI Modeling Question – Dynamic Common Sample + Buckets + Weighted KPIsCalculating Weighted SalesCumulative sum dynamicDynamic sum Datetime differenceCalculating the sum of dynamically weighted values
