Simple Dax to computer Percentage count of group totals

[Anonymous]

I have this report I have simplified.

https://1drv.ms/u/s!AlMdRxAveLesgcJA0INgUwT-qNWAyw?e=vS6Qb8

This is supoosed to be simple.  Not sure why my dax isnt working.

I want to be create a Dax for "Percentage of each purpose "  to be exact same as "%GT count of purpose".  I need to be able to place the selected Group in the Percent card.

[Ashish_Mathur]

Hi,

Is this the result you are expecting? Download the PBI file from here.

Hope this helps.

[Anonymous]

Thanks for your prompt response.

No, it doesnt work.  Notice that your solution only works when you select just one item on filter group.  It should also work with multiple selection.  And the summary card should cross filter toi your selection.  

[Ashish_Mathur]

Hi,

Please tell me the exact figure which you expect to see in the card visual and the matrix visual when you select 2 items in the slicer.  Please give a clear explanation.

[Anonymous]

The column %GT Count of purpose gives the right result.

Column (measure) Percent of each purpose should be the same as column  %GT Count of purpose.  My intention is  to drop %GT Count of purpose  and work with Percent of each purpose (using a measure calculation) as the measure will be used for other visuals like the card.

Hope that clarifies it.

[Ashish_Mathur · Accepted solution]

Hi,

In a card visual, since there is no row/column context, the result will always be 100%.  In the visual, the measure should be:

Percentage of each purpose = 
divide([*Count of purpose],  calculate([*Count of purpose], ALLSELECTED(q10[Purpose]),ALL('Group bridge dataset'[Group])))