[dircurParticipant Started: 0Replies: 1Total: 1]

Hi i would suggest watching the Calculate Sample video that is available on the course registration page.

https://powerpivotpro.com/self-paced-online-video-training/

I am totally not affiliated but I would bet you will be able to build the measure. I’m newb but you haven’t gotten a reply so i will give it a go. I am making some assumptions here. I am assuming your your conditionals are working and you want a result similar to:

Client        210_%Sales       220_%Sales     230_%Sales    Total
ABC                 15%                      85%                    0                 $20,000
DEF                 0                           100%                  0                 $45,000

Here are your measures and you would only pick the Client, % columns, and the Total_Sales column for your visual.

Total_Sales = SUM(Query1[USD Amount])
210_Sales = CALCULATE(Total_Sales,Query1[PC]=”210″)
220_Sales = CALCULATE(Total_Sales,Query1[PC]=”220″)
230_Sales = CALCULATE(Total_Sales,Query1[PC]=”230″)

210_%Sales = 210_Sales/Total_Sales
220_%Sales = 220_Sales/Total_Sales
230_%Sales = 230_Sales/Total_Sales

If these work  WATCH THAT VIDEO!!

[Author]

Posts