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.
Custom Theme Data Colors not in Proper Order
Hi all, I'm using PowerBI Desktop (January 2020) for Report Server. I have a dashboard that pulls flat data from a single table, with multiple data types represented in multiple visualizations, i.e. one visualization shows Research in Millions of Dollars from 2013 - 2018, one visualization shows Doctoral Graduation Rates from 2013 - 2018, and so on. My issue is that some visualizations also are showing 2012, but 2012 is now the darkest shade of blue, which is inconsistent with the rest of the visualizations having darker colors for more recent years. I was wondering if anyone could help me order these colors correctly. I've tried using a Conditional Column to order my color scheme, as was done in this post by v-lili6-msft, but it appears I cannot select Field Data Color, and then select Modeling -> Sort by Column. I thought this might be due to the edition of PowerBI I was using. Thanks!
