User Profile
Tomfiki
Frequent Visitor
Joined 5 years ago
User Widgets
Contributions
Re: Can't add a user to an app after updating Power BI
kenmuir71 Hi, had the exact same issue today. Managed to find out it was because one of the users in the app had an inactive e-mail address (left the company). After removing inactive users, I was able to add new users and update the app without an issue. *btw. if you have a lot of users and are not sure which ones are inactive, you can do this (if these are users from your company's Outlook address book): Select the whole list >> paste it to Excel >> filter only @ to filter only e-mail addresses >> copy paste to next sheet only the e-mail addresses >> use =A1&";" in cell B1 and pull it down >> use =CONCAT(B1:B20) in cell C1 (adjust number 20 based on number of rows used) >> copy the result from cell C1 >> create new e-mail in Outlook >> paste it into "To" field >> click somewhere else >> Outlook should display a message that "We won't be able to deliver this message to xx"Measure with values matching another table (no relationships)
Hello all, Could you please help me get this DAX formula working? ShipTest2 = CALCULATE([Shipments],FILTER(MTH_Table,MTH_Table[MTH]=VALUES(DATES[Month]))) I need to have the result in the first matrix the same as in the second matrix. I was not able to figure out how to separate the numbers for the first table into months - the column MTH in MTH_table has no relationship with Month in DATES table. The only way I was able to get this "working" was to create 12 separate measures for each month which is not very efficient, I'd say. Please don't get into why I ask this stupid question. 😄 I need to further include in the calculation another measure with another date table. I apologize if the solution is already here somewhere, I was not able to find it.Re: How to make RANKX work for columns/different categories
Hi AlB, Thank you for the reply. It doesn't work, it gives me this error. I am not sure if I can have 'AA_Master Data'[FieldInColumns] within CALCULATE without ALL/ALLSELECTED/VALUES etc. If I use them, then the result is incorrect, same as in original post.How to make RANKX work for columns/different categories
Hello, Could you please help me get this DAX formula working? I need a formula which will always display result for Customer Group by total sales for that customer (e.g. for top 3 customers). I tried to use this one (CMN = Customer): Sales_byGroup = CALCULATE([SALES+RoFo], FILTER(VALUES('AA_Master Data'[CMN]), COUNTROWS(FILTER(Customer_Groups, RANKX(ALL('AA_Master Data'[CMN]),[SALES+RoFo],,DESC)>=Customer_Groups[Min_CustGroup] && RANKX(ALL('AA_Master Data'[CMN]),[SALES+RoFo],,DESC)<=Customer_Groups[Max_CustGroups])) >0)) But, as you can see from the picture, it gives me result for top 3 values per each category - red brackets - e.g. top 3 CMN values in MSGE group, then top 3 values in FCGE group etc... what I need is MSGE sales for top 3 CMN (customers) - green bracket. Then it would do the same for 3.-10, customer and so on. I'll be gratefull for any help. Thank you, Tomas I am sorry but I cannot share the .pbix file. I can make more print-screens if required.
