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.
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.
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 )
The column Date in your visual where is it coming from ?
In VAR _
change the table by the name of your table
Bottom line, change the name of columns and tables according to your model.
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.
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.