cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Prodigy

## Get percentage after filter colom

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?

1 ACCEPTED SOLUTION
Post Prodigy

Then i get this

21 REPLIES 21
Super User

@Frixel

Try this measure, set the Format to Percentage.

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

Did I answer your question? Mark my post as a solution! and hit thumbs up
Post Prodigy

Hi @Fowmy

Then i get this error.

Super User

You need to replace it with your table and column names

Did I answer your question? Mark my post as a solution! and hit thumbs up
Community Champion

Hi @Frixel

Are these Added measures or calculated columns?

Regards
Amine Jerbi

and you can follow me on

Post Prodigy

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.

Community Champion

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

Regards
Amine Jerbi

and you can follow me on

Post Prodigy

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.

Community Champion

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
)``````

Regards
Amine Jerbi

and you can follow me on

Post Prodigy

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

Community Champion

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.

Regards
Amine Jerbi

and you can follow me on

Post Prodigy

Hope that this picture make it clear.

Community Champion

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

Regards
Amine Jerbi

and you can follow me on

Post Prodigy

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

Community Champion

replace Subject by filtered

Regards
Amine Jerbi

and you can follow me on

Post Prodigy

Then i get this

Community Champion

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

Regards
Amine Jerbi

and you can follow me on

Community Champion

What is the filter applied here??

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

Regards
Amine Jerbi

and you can follow me on

Post Prodigy

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.

Community Champion

Hey you are back lol

Regards
Amine Jerbi

and you can follow me on

Post Prodigy

I send it to you.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors