Date Segmentations based on multiple measures
Hi guys, I need to segment my products into 4 groups all with distinct MIN & MAX ranges as shown below. I am wondering how best to create a dax measure to segment my products into these groups. Furthermore, I need to essentially have the ability to use that Product Type Group Name to be used within the Legend Field of a visuals (Scatter Chart) to visually showcase the sgementation over time. Currently, the scatter chart legend field only accepts colum references and not measures. Any help would be greatly appreciated!!
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, Carlos
How do I create a measure to sum (total) up a distinct count?
Hi guys, As you can see in the picture down below I created a table with different colums: First column [VullingTotaalPerc] shows the percentage of version ID that are filled 100% and so on Second column [Count of Versies.Id] shows the count (distinct) of the total version ID. Third column [TotalVersiesIDCalculate] is a measure that I created that shows the count (distinct) of the total version ID but only for department X. Measure = TotalVersiesidCalculate = calculate(DISTINCTCOUNT(MKA[Versies.Id]),MKA[ProductieAfdeling]="COC2 en I&V") Fourth column [DistinccountVersies.id-Calculated] is a measure that I created that show the count (distinct) of versies.ID. DistinccountVersies.id-Calculated = DISTINCTCOUNT(MKA[Versies.Id]) Fifth column [COC2-Calculated] is a measure that I created - [TotalVersiesIDCalculate] divided by [DistinccountVersies.id-Calculated] to show what the percentage is of the total amount. The problem now is that when I use this formula: [TotalVersiesIDCalculate] / [DistinccountVersies.id-Calculated] the measure will divide 8 with 56 but what I want is that 8 will be divided by the total of 2533. Can anyone help me out here? Thnx!Create a new table from another and add new calculations from rows to columns
Hi, I need to create a new set of measures, but they depend of other values in a preexisting source of data. In SQL I managed this by adding CASE sentences to transform a row into a column and then I operated the columns, but in DAX I'm not sure about what is the best option, so I'm guessing that is through a new table with the SWITCH function involved. Let me explain my need: Thanks in advance
Exporting Power BI full Matric Visualization ( including scroll data ) to Power Point / PDF
Dear Folks, We are using Power BI report server to host our reports and finding it really impossible to export Visualization to Power point from PBI RS. Moreover, resolution of Exported pdf file is not so great which also does not include scroll data of Tabular / Matric visualization. Any solution is much appreciated. Many Thanks,I want to take the average of the last 3 years of the total number on a monthly and yearly basis
Hi, I have a table like this. And I want to get the second table from this table. I try to use the rollup and sum functions with the filter but I can't find any solution for getting the right amount written in the table to show in a graphic. I wrote something like this but I should get also the next 3 years and the next three years till last year. Summary last 3 years = SUMMARIZE('Summary Incident Yearly' , ROLLUP(ROLLUPGROUP('Summary Incident Yearly'[Country],'Summary Incident Yearly'[MAAND])) , "3 years AVG", CALCULATE( SUM('Summary Incident Yearly'[amount])/3 ,FILTER('Summary Incident Yearly', 'Summary Incident Yearly'[JAAR]>=2015||'Summary Incident Yearly'[JAAR]<=2017)) , "Jaartaal", "15/16/17") JAAR MAAND Country amount 2015 1 Netherlands 1082 2015 1 Belgium 174 2015 1 Belgium 8 2015 1 Luxembourg 1 2015 1 Suriname 15 2015 2 Netherlands 1181 2015 2 Belgium 212 2015 2 Belgium 5 2015 2 Luxembourg 2 2015 2 Suriname 5 2016 1 Netherlands 1244 2016 1 Belgium 259 2016 1 Belgium 23 2016 1 Luxembourg 1 2016 1 Suriname 2 2016 2 Netherlands 1252 2016 2 Belgium 264 2016 2 Belgium 19 2016 2 Luxembourg 2 2016 2 Suriname 4 2017 1 Netherlands 1088 2017 1 Belgium 243 2017 1 Belgium 17 2017 1 Luxembourg 4 2017 2 Netherlands 1054 2017 2 Belgium 288 2017 2 Belgium 15 2017 2 Luxembourg 2 2017 2 Suriname 5 AVG JAAR Maand Country AVG 15/16/17 1 Netherlands 1138 15/16/17 1 Luxembourg 2 15/16/17 1 Belgique 120 15/16/17 2 Netherlands 1162 16/17/18 1 Netherlands etc 16/17/18 1 Luxembourg etc And at the end I will get a graphic like this : Thank you for your help
Save subtotal in measure and use as dynamic multiplier
Hello all, to illustrate my issue i would like to show the following screenshot As you see i have basically 3 categories of costs which is Picking (here i add up any cost except my storage costs) and the other 2 dimensions are costs for storage&unmoved storage cost. Long story short, i am desperately looking for a way to dynamically save the cost amounts for (Storage & Unmoved) in some kind of measure which is then used to be multiplied by the corresponding "Spread" in any line. It is important to understand that this is just one block of many within my pivot table, which means i have about 100 blocs of Picking | Storage & Unmoved sums, while for any of these blocs i need to find a way to dynamically store its corresponding amount for Storage in a variable which is then used within the lines above to multiply the spread with it. Any help or hint is highly appreciated! Thanks !
Compare two tables in Power BI
Compare two tables in Power BI I have two tables named TableOne and TableTwo. I want to display a table or matrix in my report that will give me all the towns that are in TableOne, but not in TableTwo. In the example below I want to be able to display the three red tables. Please see the attachment. Thank you in advance.
