Taking two conditions and if both are true returning a new value
I have the following table: for which I have created two conditional columns which are as follows: Condition 1 = IF( MDD[Test 10] = "True" && MDD[Out] = "True" && MDD[Less than -10] = "True", "YES!", "") Condition 2 = IF( MDD[Test 7] = "True" && MDD[In] = "True" && MDD[Less than -10] = "True", "YES!", "") Both are text data types. I need to get a result of "PATTERN" to return based on "YES!" being in true for Condition 1 and Condition 2. As you can see, those results are true for Shaggy Rogers, however, I cannot get the return of "PATTERN". I created the column: Con1and2 = IF(MDD[Condition 1] = "YES!" && MDD[Condition 2] = "YES!", "PATTERN", "") However that doesn't work. If I change "&&" to "||" it works, but that is only based on one of the two conditions being met. I need both conditions to be met. I'm also curious why the table adds a new row for each name with every new column. I feel like that might have something to do with the problem as it may not be recognizing that the two conditional results for Shaggy Rogers are the same person. I am lost so any help is greatly appreciated.
Count Total, based on condition from other table
Hi all, I have a question. I want to counter the numbers of orders per categorie (Groups[Total amount between]). I have 2 tables. 1 table is about the sales with the total amounts per order. The other table is about the groupings. An amount of 5.50 falls in the category 5.01 - 7.50 for example. What I want is to count the number of orders per category. So how often have orders been placed in the different categories. I've been stuck for several days. I only get the total orders.... Here's my data. I have many rows. This is a small part of the data. Groupings table Key Min Max Total amount between 1 0 5 0 - 5 euro 2 5.01 7.50 5.01 - 7.50 euro 3 7.51 10 7.51 - 10.00 euro 4 10.01 12.5 10.01 - 12.50 euro 5 12.51 15 12.51 - 15.00 euro 6 15.01 17.5 15.01 - 17.50 euro Sales table: Only Total amount is relevant in this table. Key Order Amount Donation Amount Total amount .... .... .... 2.50 .... .... .... 2.50 .... .... .... 2.65 .... .... .... 5.50 .... .... .... 5.50 .... .... .... 7.81 .... .... .... 5.50 .... .... .... 8.00 .... .... .... 8.95 .... .... .... 9.00 .... .... .... 422.50 .... .... .... 424.00 What I want: Total amount between Count 0 - 5.00 3 5,01 - 7,50 3 7.51 - 10 4 ......... ......... 420.01 - 422.50 1 422.51 - 425.50 1 My measure now and what I get: Count = CALCULATE( COUNTROWS(Sales), FILTER(Groups, Sales[Total] >= Groups[Min] && Sales[Total] <= Groups[Max])) My example Power BI File: https://www.dropbox.com/s/u0b9tin0u4olb2t/PowerBiToCommunityQuestion2.pbix?dl=0 I hope someone can help me, I have a deadline today.
