Forum Discussion

22LACMT's avatar
22LACMT
Icon for Helper III rankHelper III
3 years ago

Percent of total data while showing restricted data for the visual

Hi,  I am trying to use the below data to show all 3 crossbuckets for each data for the Permenant Portfolio.   however, I want to show the data as a percent of the Total Combined Portfolios :  $ ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi 22LACMT ，

 

If you want to calculate the total which will not be filtered , I suggest you to try ALL() function.

Total combined portfolio =
CALCULATE (
    SUM ( 'Table'[Crossbucket30m] ) + SUM ( 'Table'[Crossbucket50m] )
        + SUM ( 'Table'[Crossbucket70m] ),
    ALL ( 'Table' )
)

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

22LACMT's avatar
22LACMT
Icon for Helper III rankHelper III
3 years ago

Thank you that seems like a good approach.  could you tell me how you would write the dax if you only wanted to show the top 2 Portfolio types?