new quick measure

4 Topics

Create New Measure count of text with a conditional denominator
I am trying to get a precentage to put in a KPI card but am having trouble. I have a data set with a flag which indicates if a certain observation is a certain type of corporate priority. I want to know what percentage of these fall into that type of priority but only for a particulat product line using a quick measure. Basically, my data looks like this: ProductSku ProductLine Type IsPriority 1 Tech toys Y 2 Tech IT N 3 Farm Tractors N 4 Tech entertainment N I have tried a few different things but can't get it to work. % priority = COUNTROWS( FILTER( SUMMARIZE ( 'Table', 'Table'[IsPriority], "Y" ), [ProductLine] = "Tech" && ISBLANK([ProductLine]) = FALSE ) ) Any suggestions? This should basiclly just be looking at line 1, 2 and 4 in the case of the fake data for the demonator and observation 1 for the numerator. Thank you!
Solved
EvalUncovered
1 year ago Place DAX Commands and Tips
656Views
0likes
2Comments
how do i select individual rows to find the difference between 2 columns
I would like to click on individual rows to present the difference between pre & post measurements in %. (POST - PRE) i'm unable to come out with new calculated columns or a new measure. PLEASE HELP!!
Anonymous
3 years ago Place DAX Commands and Tips
445Views
0likes
1Comment
DAX to compare two Dates and mark the column in Red and NA when the condition doesn't match
Hi All, In my School table i have two columns :- 1) AttendanceLocalDate 2)ServerDate. If AttendanceLocalDate column showing the attendance of students is equal to ServerDate of the attendance serverand the serverDate is equal to systemdate then only it should populate the values of Attendance localtime, if AttendancelocalDate is not equal to ServerDate[which should also be equal to today's system date], then it should show "NA" with NA text in red color. My Source table : AttendancelocalDate Location StudentID Name ServerDate 20.07.2021 11:05AM Gate1 101 Tom 20.07.2021 11:05AM 20.07.2021 10.03.22 Gate1 102 Hary 20.07.2021 10.03.22 20.07.2021 10.09.21 Gate2 103 Rohan 20.07.2021 10.09.21 20.07.2021 09.03.18 Gate2 105 Mohan 20.07.2021 09.03.18 19.07.2021 10.08.22 Gate2 109 Sam 19.07.2021 10.08.22 19.07.2021 10.03.12 Gate2 110 Sally 20.07.2021 10.03.12 My expected table matrix: It should populate Attendance total column as NA with red text where the AttendancelocalDate is not equal to serverDate[which should be today's system date only so we need to check this condition as well].Server date also has the potential to show olddates so we need to check it is today's date as the second condition after checking the first condition of AttendancelocalDate equal to Serverdate AttendancelocalDate Location StudentID Name ServerDate 20.07.2021 11:05AM Gate1 101 Tom 20.07.2021 11:05AM 20.07.2021 10.03.22 Gate1 102 Hary 20.07.2021 10.03.22 20.07.2021 10.09.21 Gate2 103 Rohan 20.07.2021 10.09.21 20.07.2021 09.03.18 Gate2 105 Mohan 20.07.2021 09.03.18 NA Gate2 109 Sam 19.07.2021 10.08.22 NA Gate2 110 Sally 20.07.2021 10.03.12 Regards Sameer
deb_power123
5 years ago Place DAX Commands and Tips
605Views
0likes
1Comment
How to create condition column based on quick measure
Hello Power BI community, I am struglling with one scenario where I have quick measure which subtracts two columns from two diffrent tables. Based on which i want to have one more column with result if 'quick measure (DIFF)' ='0' then its 'yes' or else if less than or greter than zero it should be false. The relationship between both the tables are based on Sr.No = 'Many to Many' as One to One is not possible to be created. Here is the example two data set: DataSet_FDBA Sr No FDBA 1 100 2 1500 3 1500 4 200 DataSet_ TBA Sr No TDBA Quick Measure (DIFF) Required column 1 90 10 No 2 1500 0 Yes 3 1400 100 No 4 200 0 Yes Can anyone guide me how can i achieve the required column. I am open for suggestions to redesign in order to achieve difference column and conditional yes or No column. Thank you in advance. Regards, Hemant
Hemanttripathi
5 years ago Place DAX Commands and Tips
1.6KViews
0likes
1Comment