Display data by measure in pivot table

[Rolando1980]

Hello everyone! a consultation 🙏 this is my measurement: CALCULATE(SUM(TRABEF[EffectiveTime]),TRABEF[Description]="PRODUCING") in the Description column only those that are "Producing" have data, the rest of other activities are filled with zeros. When I use this average in my pivot table and I want to see its values ​​by double clicking, I also get the zeros of the other activities Can someone help me with this problem? (excuse my english, i'm from Perú) 

[Anonymous]

Hi @Rolando1980 ,

Any updates?Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @Rolando1980 ，

Not very clear about your issue.

I have built a simplay data sample:

If you mean you want to show blank (or 0) for other Description except "PRODUCING", please try:

Measure 2 = SWITCH(MAX('TRABEF'[Description]),"PRODUCING",[Measure]) // set blank
//or set 0:
//SWITCH(MAX('TRABEF'[Description]),"PRODUCING",[Measure],0)

Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.