Forum Discussion

AlejoCumpa's avatar
AlejoCumpa
New Member
5 years ago

Hide value columns on Pivot Table

I want to aggregate three types of values, but only one in each column, like this: 

 

Currently  I am achieving it with two pivot tables, the right one behind the bigger one, like this:

 

 

 

With the three aggregate values would be : 

 

       

 

 

So I want to have that totals and subtotals but in columns only the USD values and not three of them.

 

 

 

 

 

Show and Tell
Tips and Tricks

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    AlejoCumpa you can change your measure to suppress the total

     

    Suppress Total =
IF ( HASONEVALUE ( Table[Gastos Area] ), [YOur measure DAX Expression here] )

     

    Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡