topic Re: % of the Grand Total in DAX Commands and Tips

% of the Grand Total

Anonymous — Wed, 04 Aug 2021 00:28:35 GMT

Hi Guys,

I'm creating a visualization panel to monitor the minutes of service in a call center. In one of the visuals, I would like to display, in the form of an indicator, the percentage of minutes served for a selected channel in relation to the total in a given period. I tried the formula ALL, however all filters are eliminated. When using the ALL SELECTED formula, the view always returns 100%, unlike ALL, which returns the relative value. As the image below, in the table view the % of the total of all selected works normally, but my goal is to display in the indicator. Thanks in advance.

Re: % of the Grand Total

Mohammad_Refaei — Wed, 04 Aug 2021 00:51:38 GMT

Looks like yo need to use the ALL function on the channel column not the whole table.

Re: % of the Grand Total

Anonymous — Wed, 04 Aug 2021 01:38:00 GMT

Thanks!!

Re: % of the Grand Total

giuliapiazza94 — Thu, 16 Dec 2021 09:41:23 GMT

Can you write here the dax formula "% ALL SELECTED" please? 😁