Forum Discussion
Add custom field to selectedvalue column in matrix
Anonymous
3. I modify the calculate formula but 'savi' part seems not calculate correctly, you can try to fix them. (logic: calculate without raw types table and use 'in' operator to filter calculate result with new table field values)
that because i ask for help here, in that way it totaly wrong counting on totals and not include placeholders values, also in example only 2 Types(Unconnected), but imagine what i have them over 100
Hi Analitika,
>>that because i ask for help here, in that way it totaly wrong counting on totals and not include placeholders values,
They may related to multiple aggregates on the calculation, take a look at the following blog if helps.
Measure Totals, The Final Word
>> also in example only 2 Types(Unconnected), but imagine what i have them over 100
Ok, I think my formulas may not suitable to handle this scenario.
How about direct append some template blank row to the raw table with corresponding type codes? After these steps, these types exist in your table and you can simply use DAX formulas to replace display contents.
Regards,
Xiaoxin Sheng