Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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?
Solved! Go to Solution.
@Frixel
Try this measure, set the Format to Percentage.
%f =
DIVIDE (
counta(table[filterd]),
counta(table[subject])
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
You need to replace it with your table and column names
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @Frixel
Are these Added measures or calculated columns?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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.
Did you try to change the name of the tables accordingly in @Fowmy formula like he said?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
i realy don`t know wkat to do but i think like this? But then noting appearts and i have a erros.
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
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
you need to replace "table" by the name of the table where you apply the Counta
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
replace Subject by filtered
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
In one of your visual tables there a column name Count of Filtered...what is it ? Where is it coming from?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
What is the filter applied here??
Can you please share your file in Private?? I sent you a private message.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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.
Hey you are back lol
Use OneDrive , DropBox, GoogleDrive....For your file
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
88 | |
86 | |
83 | |
65 | |
49 |
User | Count |
---|---|
127 | |
108 | |
88 | |
70 | |
66 |