Forum Discussion
Would this setup work?
Miquel_llado ,Can you share sample data and sample output in table format?
- Miquel_llado5 years agoNew Member
Sadly not at this point but the table I provided before should be a good enough example, there are three types of rows I should control in this report. If type is "suma" it should retrieve a sumatory of all rows starting by any of the numbers in "sums" from data table. If it is "total" it should retrieve a sumatory of provided lines in this same table. If it is "literal" it should retrieve a blank to show an empty line acting as a separator in the report.
My biggest issue here is how to tell dax "sum all the lines starting by ANY of these comma separated values". There is an easy way to do this, like creating a line for each value in "sums" and redirecting it to a certain line, but then I'll end with dozens of lines in this table and I'm trying to keep the model while learning some new dax solutions.