Help with Divide

[siac16]

Hi

I currently have a table with the following fields

Source	Do you use it?	Gender	Age	Income
Internet	YES	M	18-25	1000-2000
Internet	NO	F	26-35	2001-3000
TV	YES	M	36-45	1000-2000
Magazine	NO	F	18-25	5001-6000

And I created the following measure:

Medida = DIVIDE(COUNTA(M_Medios[Do you use it?]),1052)

The 1,052 is because there are 1,052 answers for each source (internet, TV, Magazine)

What I'm trying to do is to obtain the percentage of each source that had answered YES in a bar chart.

But when I try to use Slicers the data keeps dividing for 1,052 instead of the new total for each source.

For example, If I use a slicer for Males, the Internet should be 100% YES, wherein on the other hand if it is female it will be 0%. But currently, it is showing 50% for Male slicers.

[v-angzheng-msft · Accepted solution]

Hi, @siac16 

A measure could be like this:

Measure = 
var _DIVIDE=
DIVIDE(
    CALCULATE(COUNT('Table'[Do you use it?]),FILTER(ALLSELECTED('Table'),'Table'[Do you use it?]="YES")),
    CALCULATE(COUNTROWS('Table'),ALLSELECTED('Table'))
    )
VAR _IF=IF(_DIVIDE=BLANK(),0,_DIVIDE)

RETURN _IF

 Result:

Please refer to the attachment below for details.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

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

[amitchandak]

@siac16 , Try a measure like

divide( countrows(Table), calculate(countrows(Table), allselected(Table)) )