Search found 9 matches

by eriks
Thu May 28, 2020 4:30 pm
Forum: PowerPivot/DAX
Topic: Problem with filtering a 0 value
Replies: 2
Views: 229

Re: Problem with filtering a 0 value

Thanks! It works with: % voldoendes = divide(countrows(filter(Toetsresultaten,Toetsresultaten[voldoende]="J")+0),countrows(Toetsresultaten))
by eriks
Wed May 27, 2020 4:44 am
Forum: PowerPivot/DAX
Topic: Problem with filtering a 0 value
Replies: 2
Views: 229

Problem with filtering a 0 value

I have a question regarding the filter function. I have a divide function which works well. However, if the result of the (first) filter is 0 the resulting value is empty (it does not return 0%). As such, it does not show in the results. Does anyone know how to fix this? This is the DAX formula % vo...
by eriks
Mon May 04, 2020 9:21 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: Why does this calculate work (and others don't)?
Replies: 3
Views: 1070

Re: Why does this calculate work (and others don't)?

Thanks for your answer. I understand now that you can filter the customers table based on context transition (only count customers > 5000 dollar). However, this measure is situated in the customers table. So basically you can filter a measure in a lookup table based on another look up table as e.g. ...
by eriks
Wed Apr 22, 2020 11:00 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: Why does this calculate work (and others don't)?
Replies: 3
Views: 1070

Why does this calculate work (and others don't)?

I have a small question during the excercises in the book. I cannot figure out why if you use Customers with Sales Greater Than 5000 = CALCULATE(COUNTROWS(FILTER(Customers;[Total Sales]>=5000))) is is working well while you put countries on rows and it is not working for Total Number of Customers = ...
by eriks
Fri Apr 10, 2020 8:03 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: Import excel file Adventure works: errors in products table?
Replies: 1
Views: 294

Import excel file Adventure works: errors in products table?

When I try to import the excel files (adventure works) I get the message of an error with the products tabel. Do I do something wrong?
by eriks
Mon Apr 06, 2020 11:36 pm
Forum: PowerPivot/DAX
Topic: Table: relationships maybe required (pivot table)
Replies: 3
Views: 621

Re: Table: relationships maybe required (pivot table)

Thanks for you answer. But I still cannot solve it. As you cannot open my file, I have attached two screenshots. Hopefully it helps you or others to help me to fix this problem.
by eriks
Thu Apr 02, 2020 9:23 pm
Forum: PowerPivot/DAX
Topic: Table: relationships maybe required (pivot table)
Replies: 3
Views: 621

Table: relationships maybe required (pivot table)

I have created multiple tables with relationships by means of power pivot. It seems okay, the only thing is that Excel keeps mentioning that relationships maybe required. Does anyone know what the problem could be? In my opinion, I have made all the necessary relationships between tables in Power Pi...
by eriks
Mon Mar 09, 2020 11:06 pm
Forum: PowerPivot/DAX
Topic: Question regarding function calculate (filtering text)
Replies: 1
Views: 194

Question regarding function calculate (filtering text)

I have a column (Integraal Product) in power pivot which contains numbers and in some cases an "i", "GK" or a blank space. I want to calculate the average of this colum while skipping the rows with text. I have tried Meting 2:=calculate(Tabel1[Integraal product 1];Tabel1[Integraa...

Go to advanced search