Calculation groups or Unpivot
Hi, I have a data set of monthly Stock data. It is a flat table of about 250,000 lines. Every line contains, besides the basics: date, stockID, price, 100 featurs of the stock. Things like Pricer/Earing ratio, market cap, etc. My task is to create measures such as TopN based summations based on these features. I have two choices (maybe more): 1) Unpivot the data and then have 25 mio lines with two columns feature_name and feature_value 2) Create a placeholder measure for every feature abd the use calculation groups (in the Tabular Editor) to create the requiered measures on SELECTEDMEASURE. Which one would you chose and why ? I'm particular worried about performance issues. Also the restrictions of using calculation groups. Many thanks in advance
Unpivot Column with Different Calculation Applied
Hi there, I am trying to unpivot data matrix using pwoer query but the data calculation is not only using summraize but also average since the value have different value format, iie. absolute number and percentage. Is it possible to apply this purpose using unpivot column in power query? Here is the data matrix example: I would like to convert (unpivot) and visualize the table into this: Kindly share your thoughts on this. Thank you in advance!
Bypass an explicit filter to have a global total
Hi, I have a view where I show a total of spendings per month. Then I divide this total in four categories in the purpose of separate spendings less than, equal to (not remarquable), without comparision with or greater than the previous month. My objective is to show uniquely the values where the variation to the previous month is greater than 1% of the total of the current month. For instance, the first line of the category (Inferiores mas de 10% al mes anterior) is correct because the variation is greater than the total (30 970 000 / 100 = 309 700) but the fourth one is not supposed to appear. ((616 000 - 501 000) < 309 700) My measure for the total global is this : Mes actual general = CALCULATE([Mes actual], ALLSELECTED('Facturas Proveedores')) My issue is that when I use my measure "Total mes actual" which is supposed to be global, I have the total of the filtered category. I know that it is the normal behaviour of ALLSELECTED because we cannot remove the explicit filters however I would like to find a way to get this global value, either with DAX or modeling or any proposition you can make. Thanks !
Calculating percentage off of a measure in a table
Hello, I have a regular table visual that contains an unpivot column (Grade, Gender) and a measure to calculate students who attend the school more than 90% of the time (which is based on IDs and a few other calculated columns). I am trying to currently do a percentage of that measure on the unpivot column in the visual. However, it is not coming up accurately since the denominator is duplicating records for the unpivot column. However, I have been unsuccessful so far. Any help would be much appreciated.
