Cumulative Count by Category, Sorted by Frequency
Hello. I have data that needs to be arranged by frequency (how many claims have occured) per location. The result is a bar graph with the locations with the most claims appearing first: Nice! First part is done. I then need to create a line that cumulatively sums up the total number of claims for each location, then displays it as a percentage of the total number of claims (for the filtered timeframe). Hypothetically it would look something like thisq (this screenshot comes from Excel): However I cannot seem to get the line to cooperate. My last attempt ended up looking like this: Any feedback on how to make this line function like the one above would be much appreciated. Thank you!
How to sum the last 5 rows separated by categories in power bi using DAX syntax
Hi everyone, I'm trying to sum the last 5 rows in a table for each row and divided by category, such as the example below that I did in Excel. The expected result is the column D 'RUNNING_SUM'. If I would write this in SQL, I would use SUM OVER PARTITION. Could you anwser that for me? .
Divide Dax Formula by category
Hi everyone, I wish to have a visual card of the information which has been circled in red at the end of the image. I am trying to obtain the "total Project Average" which can be seen in the bottom of the first image to display this info on a card visual. The column "Actual Weighted Completion" is calculated by multiplying the columns of "Completion" and "Weighted Task" together. This total project average is calculated by summing the "Actual Weighted Completion" according to the respective project (e.g. Assignment 1). So the summation of the "Actual Weighted Completion" for assignment 1 is 56%, for assignment 2 is 0% and for assignment 3 is 100%. Hence getting the average of these 3, you get the value of the "Total Project Average" of 52%. If you divide (to get the average) only the "Actual Weighted Completion" column you get the result of 10%, which is not the result I wish to obtain. Was wondering if I could get some assistance on this and help me out. Thank you in advance.How to categorize or label date on a matrix/table ?
Hello! I want to "categorize" date on a matrix/table, just to clean it up and avoid repeating words in the rows. My matrix/table is this, each row is the value of a measure and I have 2 fact tables, INC_table & REQ_table This is my visual currenly, with the values shown per week. And this is how I would like to have as the visual I'm lost and not sure how can thisw be accomplished, If you have any ideas please send them my way Thanks in advance, CarlosSUM grand total per category
Hello everyone! I am new to Dax and am guessing the solution is right under my nose, but I've exhausted my limited knowledge and need some guidance. I have category (location) and subcategory (centers). A location can have more than one center. My dimension table Unidades uses the subcategory as primary key, since they aren't duplicate. There's also a fact table containing the amount of extra hours (R$) per location (category). When I put the information on a visual it repeats the corresponding overtime for every center according to its location. That's OK. My problem is that I need to add up the grand total of overtime hours, but my measure is adding the overtime for each center and not the location, wich means it adds duplicate values. How do I get the correct sum? Thank you in advance.
Divide all categories by one category-total
Hello all, If anyone can help me it is much appreciated. I have a financial report were I divide the differend revenues by the total revenue. This is working. But now I like to divide the costs also by the total revenue. I first made a formula for the total Revenue. Kosten%4 = CALCULATE(SUM(GeneralLedgerBalances[AmountDC]), 'Volgorde'[Rapportage omschrijving] = "Omzet verpakken", ALLSELECTED('Rapportage_Grootboek'[oms25_0], 'Rapportage_Grootboek'[reknr])) (I added 'Rapportage_Grootboek'[reknr]), because 'Rapportage_Grootboek'[oms25_0] is sorted by Rapportage_Grootboek'[reknr])) After this I first tested if I got the right percentages of the revenue, and this was working. Kosten%1 = VAR Omzetverpakken = CALCULATE(SUM(GeneralLedgerBalances[AmountDC]), 'Volgorde'[Rapportage omschrijving] = "Omzet verpakken", ALLSELECTED('Rapportage_Grootboek'[oms25_0], 'Rapportage_Grootboek'[reknr])) RETURN DIVIDE( CALCULATE(SUM(GeneralLedgerBalances[AmountDC]), ALL(Volgorde[Rapportage omschrijving]), ('Volgorde'[Rapportage omschrijving]) = "Omzet verpakken") , Omzetverpakken ,0) Now I thought it was simple to get all the percentages by replacing the "Numerator" in: Kosten%2 = VAR Omzetverpakken = CALCULATE(SUM('GeneralLedgerBalances'[AmountDC]), 'Volgorde'[Rapportage omschrijving] = "Omzet verpakken", ALLSELECTED('Rapportage_Grootboek'[oms25_0], 'Rapportage_Grootboek'[reknr])) RETURN Divide( SUM('GeneralLedgerBalances'[AmountDC]), Omzetverpakken, 0) For the revenue it is still working, but for the other categories not. I get only zero's because of the alternate result. So, I deleted the Divide functions and made the following formula: Kosten%7 = VAR Omzetverpakken = CALCULATE(SUM('GeneralLedgerBalances'[AmountDC]), 'Volgorde'[Rapportage omschrijving] = "Omzet verpakken", ALLSELECTED('Rapportage_Grootboek'[oms25_0], 'Rapportage_Grootboek'[reknr]), VALUES(Volgorde[Rapportage omschrijving]) ) RETURN SUM('GeneralLedgerBalances'[AmountDC]) / Omzetverpakken For the revenue this is still working, but now I get a message for the other categories. See the results below. By the way, the percentage of the Total 0,23 is shown and is correct. I have search a lot of time to solve this problem, but I overlook something. And I hoop that one of you can help me with this. Thank you in advance!
