Overall Figure/Table/Graph by summary of Measure in DAX
Hi I've been struggling with this for a while, and no amount of googling has got me any closer. I have a dashboard which monitor people carrying out tasks on an app. If they get to the end, they are classed as 'Fully Compliant'. I have a table on my dash that illustrates this at a user level, which works fine. (see below mocked up in dummy data), but regardless of how I've tried to do it, I can't get an overall figure. From the above the: User is a field in the table Orders counts the number of rows in the table for each user Fully Compliant = IF([App Used in Full] <> [Orders],"N","Y") [App used in full] counts completed rows in same table The issue that I have is that the company want to have a summary of how many users are compliant, and have visual as numbers, graphs etc. See below mock up in Excel. There are numerous date/category filters on the dashboard from that table, which still need to work for the 'Fully Compliant' field, which is why (unless you guys know a way) I can't use Power Query. I'll obviously need to tie in the User to the formula, but I can't seem to group by the Y/N measure to do Countif etc. I've tried creating a table based on SUMMARIZECOLUMNS which also did not work. Any and all help is much appreciated. Thanks Shani
Calculate dynamic field in a table
Hello, I have data fed from an excel sheet of an investment portfolio, this table contains columns like (Investment, type, purpose, value..etc) In the type column, I have 3 categories (Properties, Stocks, and cash). What we want to achieve is to pull daily stock prices from the internet (which I managed to do that), then I have to calculate the networth by sum the values of properties, cash as well as the stock value (based on the current stock price) I am still a begginer, and I have managed to pull the stock prices, however I am stuck in creating a table that have those nearly static values (properties and cash) as well as a field for those dynamic wealth (stocks) and display that using pie charts and stuff. what should I do, please help
