Forum Discussion

Rolando1980's avatar
Rolando1980
Regular Visitor
4 years ago

Display data by measure in pivot table

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ú) 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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