Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Divide row by column total while keeping date filter

Hi,   I am trying to generate a column total that I can use in measures to divide each row by for a % of total.  I see the quick measures for "total for category" with and without filters applied, ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you Kishore_KVN , but I get the same result when I make that change.  It just returns the filtered value of FTEs for the location, not the column total.  What I am trying to get is the 4078 figure in each row. 

 

 

Kishore_KVN's avatar
Kishore_KVN
Icon for Solution Sage rankSolution Sage
3 years ago

Hello Anonymous , using all and all selected will give the total by remove all the external filters on that calculation. Can you please refer below screenshot for your reference. 

If possible please share sample pbix will try to provide maximum help. 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks for staying with me here!  I can't send my original PBIX file, but I wonder if my issue is that I have multiple connnected datasets and this table is referencing a location column from another table that is linked by relationship to the employee table.