New Product label

Question

Hello,&nbsp;&nbsp;I have a pbi report I'm trying to create that takes a Product name that has a DNU (do not use) label with it and strips it off. When I do this, I lose the total row. See screenshots below and link to model. Any thoughts?&nbsp;&nbsp;https://drive.google.com/file/d/1rx6IULdeDI985CL8Zm6wv6Q6Sli6LNgk/view?usp=sharing&nbsp;&nbsp;&nbsp;

mkarwa-123 · Answer

Hello&nbsp;ajrodr82&nbsp; instead of a meaasure you need to add a column to the table.&nbsp;Did I answer your question? Mark my post as a solution! If my post helped you, why not give it a thumbs-up?

ajrodr82 · Answer

Well, I do know that I could just do a column to solve the problem but the dataset is 4+billion rows and I'm trying to avoid that kind of a change requiring me to redeploy and processing all the partitions. Is this possible with a measure somehow?&nbsp;

anonymous · Answer

Hi&nbsp;ajrodr82&nbsp;,
&nbsp;
If you don't have a column that provides row context, the measure returns an aggregated value.&nbsp;The same is true for two measures, which return two aggregated values. The&nbsp;aggregated value of the measure itself is a total, so you don't need another row for totals.
&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

Forum Discussion

New Product label

3 Replies

Related content

Production Lessons

Data Label

Stacked Column Chart Data Labels

Number of Core Products sold through assemblies

When PBIP to Production?