Forum Discussion

devenchj's avatar
devenchj
Icon for Helper I rankHelper I
6 years ago
Solved

Share % Calculation not working while setting up "Sort By Column" feature

Hello Everyone,   Having issue with Share % measure while setting up "Sort By Column" feature, which seems bug. without enabling Sort by column in SeriesDim table,  Share % works correctly. but I ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    I think, all need to be used and as long as that is part of seperate dimension it should work

    Total Sales Amount = CALCULATE([Sales Amount],filter(all(SeriesDim),SeriesDim[SERIES_NAME] = "All Models"))
    Find the attached file
     
vivran22's avatar
vivran22
Icon for Community Champion rankCommunity Champion
6 years ago

Hello devenchj,

 

I have used the following measures:

 

Sales Amount = SUM('Fact'[AMT])

OverAll Sales = CALCULATE([Sales Amount],ALL('Fact'))

% Sales = DIVIDE([Sales Amount], [OverAll Sales])

 

and getting the following results:

 

Is this what you are looking for?

 

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn