Matrix visual tooltip to show values
I have a table of elements such as: Each person can have multiple categories. From this table I have managed to create a matrix like this: In order to achieve this (with help from this forum) I used the following Measure to aggregate the numbers: Measure = if(VALUES(Classification[Classification])=VALUES(Classification_dup[Classification]),0,CALCULATE([People],CALCULATETABLE(SUMMARIZE(VALUES(Data[IdPerson]),Data[IdPerson]),ALL(Classification),USERELATIONSHIP(Data[Classification],Classification_dup[Classification])))) I am now struggling with trying to create a tooltip that shows the Name (or ID) of the people in each cell, i.e. I want to create something that liiks like this: The mock up file is attached below: https://www.dropbox.com/s/i2wrw6zowwjzxs0/Cross%20matrix%20example%20post.pbix?dl=0 I would be very grateful for any help.
How to exclude single cell from a column to calculate total
Hi everyone, Before starting thanks for the support. I have these tables: sales, products, stores, and one table with exceptions, which means a product is not going to be sold in a particular store, below the structure: My question is, how can I in a matrix don't take the value for Product 2, and store 4 (an exception) to calculate the Avg total, in this case, the result must be 28, not 19 because product 2 is not for sale at the store 4, is it possible in the matrix? or using DAX?. Thanks a lot for the support and time, Regards
Max function showing wrong. Need help for Powerbi Matrix total
Hello everyone, I need your support to solve and understand issues in my DAX. I have a transactionDB of all bank transaction like below: date company type Source Bank amount 01-Apr-22 Company 1 Credit Bank Bank A 10000 01-Apr-22 Company 1 Credit Bank Bank B 10000 01-Apr-22 Company 1 Debit Bank Bank B 500 01-Apr-22 Company 2 Credit Bank Bank C 10000 01-Apr-22 Company 2 Credit Bank Bank D 10000 01-Apr-22 Company 2 Debit Bank Bank C 10000 02-Apr-22 Company 1 Debit Bank Bank A 3000 02-Apr-22 Company 1 Debit Bank Bank B 1000 03-Jun-22 Company 2 Credit Bank Bank D 30000 03-Apr-22 Company 1 Credit Bank Bank A 5000 03-Apr-22 Company 2 Credit Bank Bank C 60000 03-Apr-22 Company1 Debit Bank Bank A 2000 03-Apr-22 Company 2 Debit Bank Bank C 10000 03-Apr-22 Company 2 Debit Bank Bank D I want to build a Dashboard with Matrix like below. Users wants to see today (slider date 3/06/2022) 1. Opening balance of 03/06/2022 (sum of all debit - credit as of of 2/06/2022) 2. Sum of credit happened on 03/06/2022 3. Sum of debit happened on 03/06/2022 4. Closing balance of 03/06/2022 If the user changes the date slider to 2/06/202, they will see above status as of 02/06/2022 Solution 1. Opening Measure (This is working fine with slider and all values) CALCULATE( SUM(transactionDB[Amount]), FILTER(ALLSELECTED(transactionDB[date]), ISONORAFTER(transactionDB[date],MAX(transactionDB[date])-1,DESC))) 2. Credit (Matrix is showing wrong calculation) CALCULATE( SUM(transactionDB[credit]),FILTER(ALLSELECTED(transactionDB[date]),transactionDB[date] = MAX( transactionDB[date]))) I want to show the credit happened in Slider date ie. 03/06/2022. It is not working as expected. 3. Debit(Matrix is showing for wrong calculation) CALCULATE( SUM(transactionDB[debit]),FILTER(ALLSELECTED(transactionDB[date]),transactionDB[date] = MAX( transactionDB[date]))) I want to show the debit happened in Slider date ie. 03/06/2022. It is not working as expected. 4. Ending balance (This is working fine with slider and all values) CALCULATE( SUM(transactionDB[Amount]), FILTER( ALLSELECTED(transactionDB[date]), ISONORAFTER(transactionDB[date], MAX(transactionDB[date]), DESC) ) ) Please help to solve this issue. I understand that using max function will summarize the value based on maximum date filtered within its context. But i would like to show the debit or credit happened for that particular date as per date slider ChandeepChhabra GuyInACube johnt75 tamerj1Create Calculated Columns from matrix's column
I have created a matrix table below (sorry that I have to cover the data). I would like to include the following new columns into the matrix table at the end of the table. (Entity = Subsidiary) - Total Entity = Entity 1 + Entity 2 + Entity 3 - Adj Entity - Total all = Total Entity + Adj Entity ** Adj Entity currently is also one of the subsidiary in the data set. So the end result will be like Basically I would like to create new "calculated column" that derived from the columns from the matrix. Also I cannot create another measure and drop it into visual - Values, cause it will create 2 amounts for each entities. I just need the 3 columns at the end of the matrix. I thought of duplicate the same fact table, change the subsidiary value to Total Entity (exclude Adj Entity) and append the table to the existing table. This will fake the "Total Entity" as one of the subsidiary therefore archieve the result that I want. However, I do not really wish to do this, as the appended fact table will be very big which consume the space / memory. Hope to seek some helps here. Thank you.
Percentage of row total with another sum value measure
Hello, I trying to figure out on how to solve this problem, if it's even possible. I have a table Date - with years, another table Category (a,b,c) and facts table with value. Year A(PC) B(PC) C(PC) 2000 8 9 88 2001 5 15 55 2002 23 45 11 2003 69 35 22 2004 14 22 33 2005 8 22 5 I want to make a matrix with new calculated fields and the add percentage of row total to it. Firstly I've created a measure where I sum up values from the category A with Category B - that gives me the column A+B(PC). And then create another measure to get the percentage of row total. The problem is I'm not sure on how to get the calculated filed A+B(PC) into the matrix as a seperate column and include it in the sum of row total. Year A(PC) A(%) B(PC) B(%) A+B(PC) A+B(%) C(PC) C(%) Total Total % 2000 8 6,6 9 7,4 17 13,9 88 72,1 122 100 2001 5 5,3 15 15,8 20 21,1 55 57,9 95 100 2002 23 15,6 45 30,6 68 46,3 11 7,5 147 100 2003 69 30,0 35 15,2 104 45,2 22 9,6 230 100 2004 14 13,3 22 21,0 36 34,3 33 31,4 105 100 2005 8 12,3 22 33,8 30 46,2 5 7,7 65 100 Thank you for all the advice!!Filtering "Red" and "Green" in a project with Measures
I have a project created with Measures. Can we filter red and green with measure in a matrix? To give more detail, i would like to filter the matrix in attached image by green or red. Ie. if i filter green, Region C1-Z August value shouldnt be visible. On the other hand, rest of the green values in August column should be visible. Another example ie. if i filter green Region C1-Y September value shouldnt be shown. But, rest of the green values in matrix including Region C1-Y August value should be visible. The rows containing any red value should not be deleted completely. I hope its clear. Looking forward for your suggestions.
