Get percentage after filter colom

[Frixel]

Hi all,

I'm trying to get in the 3rd table the percentage of the 1st and 2nd table.
Like as; sum from 31/423*100= 7.328

How to do that?

[Fowmy]

@Frixel 

Try this measure, set the Format to Percentage.

%f = 
DIVIDE (
    counta(table[filterd]),
    counta(table[subject])
)

[Frixel]

Hi @Fowmy 

Then i get this error.

[Fowmy]

@Frixel 

You need to replace it with your table and column names

[aj1973]

Hi @Frixel 

Are these Added measures or calculated columns?

[Frixel]

Hi @Fowmy  & @aj1973

Thanks for your reactions.

The first table (count of subject) is from 'Fields'

And the table Count filterd is is the same as table 1 but now there is a filter voor specific words in the subject.

So i want to see how much percent of the filterd subject is from all the mail(count of subject) that day.

[aj1973]

@Frixel 

Did you try to change the name of the tables accordingly in @Fowmy formula like he said?

[Frixel]

@aj1973 @Fowmy 

There is no more error at the moment but i see not the right percentage.

Sorry for my unknownes but this is new for me.

[aj1973]

@Frixel 

Not clear how your model looks like but try to add SELECTEDVALUE('Yourtabel'[Column Date]) to calculate the count before you divide both values.

%f = 
var _Date = SELECTEDVALUE(yourtabel[datecolumn])
var _CountFiltered = CALCULATE(counta(table[filterd]) , yourtabel[datecolumn] = _Date)
var _CounTtSubject = CALCULATE(counta(table[Subject]) , yourtabel[datecolumn] = _Date)
return
DIVIDE (
    _CountFiltered,
    _CounTtSubject
)

[Frixel]

@aj1973 

i realy don`t know wkat to do but i think like this? But then noting appearts and i have a erros.

[aj1973]

@Frixel 

The column Date in your visual where is it coming from ?

In VAR _

_CountFiltered

change the table by the name of your table 

Bottom line, change the name of columns and tables according to your model. 

[Frixel]

@aj1973 

Hope that this picture make it clear.

[aj1973]

@Frixel 

you need to replace "table" by the name of the table where you apply the Counta

[Frixel]

@aj1973 

i don`t know what the table is for the filtered colomn.(row4)

[aj1973]

@Frixel 

replace Subject by filtered

[Frixel · Accepted solution]

@aj1973 

Then i get this 

[aj1973]

In one of your visual tables there a column name Count of Filtered...what is it ? Where is it coming from?

[aj1973]

@Frixel 

What is the filter applied here??

Can you please share your file in Private?? I sent you a private message.

[Frixel]

@aj1973 

Sorry for the long time to wait but i have a short holliday.

I will mail the file to you private but i don`t see the option for a attachemnt.

[aj1973]

Hey you are back lol

Use OneDrive , DropBox, GoogleDrive....For your file

[Frixel]

@aj1973 

I send it to you.