Forum Discussion

Khushboobarai's avatar
Khushboobarai
Helper IV
6 months ago
Solved

% CT SALES

I have matrix visual  3 matric visaul one has column as date, one has month and last has year  i want to claculte % share which we can do directly frm the value option as to show the value as % of ...
Need Help
  • rohit1991's avatar
    rohit1991
    6 months ago

    Hii Khushboobarai 

     

    Use this single measure for % of Column Total (Sales):

    % Column Total Sales =
DIVIDE(
    [Sales],
    CALCULATE(
        [Sales],
        ALLSELECTED(YourTable[RowField])
    )
)
alish_b's avatar
alish_b
Super User
6 months ago

Hi Khushboobarai ,

 

Sorry I had trouble following that. Could you please share a representative sample of what you are working with and the expected output? This would help us to support you better.