## Search found 30 matches

Mon Dec 17, 2018 10:11 pm
Forum: Testing
Topic: Testing URL
Replies: 5
Views: 2083

### Testing URL

This post is to check the URL that gets included in the post notification email.

Thanks and regards
Ramana
Wed Dec 05, 2018 8:47 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Page 67 Results of OR formula not showing up
Replies: 1
Views: 2183

### Re: Page 67 Results of OR formula not showing up

Hi,

The formula is correct.

You can check like this:
In the Power Pivot window, in the new column, filter to check if there are blanks.
Then check the column DayNumberOfWeek to see if it contains blanks.

Best wishes
Ramana
Mon Dec 03, 2018 8:11 am
Forum: Help with the Book "Supercharge Power BI"
Topic: DAX Topic FILTER() - Page 106 "Under the Hood"
Replies: 5
Views: 792

### Re: DAX Topic FILTER() - Page 106 "Under the Hood"

Hi,

I also made a mistake in it.

Following is the right formula.

Total Customers with Income of \$ 80,000 Under the Hood =
CALCULATE(COUNTROWS(Customers), FILTER(ALL(Customers[YearlyIncome]), Customers[YearlyIncome] >= 80000))
Sat Dec 01, 2018 9:32 am
Forum: Help with the Book "Supercharge Power BI"
Topic: DAX Topic FILTER() - Page 106 "Under the Hood"
Replies: 5
Views: 792

### Re: DAX Topic FILTER() - Page 106 "Under the Hood"

Hi, It is a typo in the second formula. It should be Total Customers with Income of \$ 80,000 Under the Hood = CALCULATE(COUNTROWS(Customers), FILTER(Customers, Customers[YearlyIncome] >= 80000)) Thanks for bringing it out. We will add in errata. With this formula the results are FILTER Under hood.pn...
Fri Nov 30, 2018 8:38 am
Forum: Help with the Book "Supercharge Power BI"
Topic: DAX Topic FILTER() - Page 106 "Under the Hood"
Replies: 5
Views: 792

### Re: DAX Topic FILTER() - Page 106 "Under the Hood"

Hi, The way CALCULATE function works is - FILTER first, EVALUATE next. i.e. the Filter part of the formula is executed first and then the evaluation is done on the filtered table. So in your under hood formula, you have the FILTER function that has ALL(Customers). This removes all initial filters ap...
Sun Nov 25, 2018 4:48 pm
Forum: PowerPivot/DAX
Topic: Creating Conditional Columns Filtered Within Rows
Replies: 2
Views: 398

### Re: Creating Conditional Columns Filtered Within Rows

Hi, Place a Calculated Column with the following formula (assuming your table as 'Sample') = VAR ThisIDGender = 'Sample'[Gender] VAR ThisID = 'Sample'[ID] RETURN IF(CALCULATE(COUNTROWS('Sample'), FILTER(ALL('Sample'), 'Sample'[ID] = ThisID), FILTER(ALL('Sample'), 'Sample'[Gender] = ThisIDGender)) = ...
Sun Nov 25, 2018 3:27 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: To buid a table with distinct columns fron two tables
Replies: 4
Views: 529

### Re: To buid a table with distinct columns fron two tables

Hi, You can do it in Power Query. Follow these steps. 1. Merge the tables Products and Sales using ProductKey column. Use Merge Tables as New option. It creates a new query - Merge1. 2. In Merge1, expand the Table column (column on the extreme right), keeping only CustomerKey and ExtendedAmount colu...
Wed Nov 21, 2018 9:34 am
Forum: Help with the Book "Supercharge Power BI"
Topic: To buid a table with distinct columns fron two tables
Replies: 4
Views: 529

### Re: To buid a table with distinct columns fron two tables

Hi, From where the [Total Sales] coming from? Do you have a Sales table with SalesAmount column? and is [Total Sales] a measure with the formula as SUM(Sales[SalesAmount])? I am assuming that you have the above information. Otherwise you need to have that. Sales table is your Data table. You have 2 ...
Sat Nov 03, 2018 9:57 am
Forum: PowerPivot/DAX
Topic: trying to convert excel formula to PowerBI
Replies: 2
Views: 597

### Re: trying to convert excel formula to PowerBI

Hi, First, you should stop thinking about data in cells. In Power BI data exists and referred to in columns and not in cells. Second, unlike in Excel the calculations can happen in any order across rows. i.e. not necessarily in the order row 1, row 2, ... Actually a sample workbook would be easy to ...
Wed Oct 31, 2018 8:51 am
Forum: Power BI Desktop/Service
Topic: Filtering formula by various dates
Replies: 9
Views: 1392

### Re: Filtering formula by various dates

Hi, Is this resolved?