How to use DAX formula to calculate multiple calculation in specific cell like the one in excel
Dear all, I'd like to know if it's possible to use a formula in a specific cell that would be the result of let's say cell1/cell2 or cell1*cell2. This data involves a lot of formula calculations, but all of these calculations are not structured. Some calculation are reverse calculation. As an exmple, if i want to calculate production for subcategory Sawah sempadan 1 & Sawah Sempadan 2, i just follow the strutured order (1st find the average, 2: Production of each main block = product of average X cultivated area of each subcategory. However, if want to find the average for only main block scheme: Sawah Sempadan, I need to use reverse calculation. I am providing the excel file sheet for your reference, the one in red shade are wrong structured way to calculate the the average of sawah sempadan. https://docs.google.com/spreadsheets/d/1NYQ9k8CRpusFVlt1Dy8puJolNFrXRElm/edit?usp=sharing&ouid=116361518361091014147&rtpof=true&sd=true Thanks everyone,
Is possible to show One Metric with details and rest simple by using Dax functions ?
Hello, I need to show measures dynamically in Grid or Matrix visual, I have a set of data with over 20+ Metrics precalculate in SQL. Those measures come from different Fact tables and it is with tabular data. Based on from audience request I am looking to see if can be possible to do this: Using Dynamic Slicer show in the front one measure with some extra analisis (frame in blue) then keep showing the rest of the other measures simple as thier value come. I am be able to change dynamically the blue frame but I wondering if it is possible to show the rest of the measures. I am looking to do it in DAX but let please know if this can be done under Dax or under Query Editor but my preference is under dax. For example from the slicer metric selection I choose metric A. This one show all the details related variance, vol, vol% , impact, etc. but then rest of the metrics not select show next the metric selected it. Then if Metric B is select show the details and rest of the metrics simple.(metric b is back wit rest of the metrics) If the Metric c is select the that change in the blue frame and now metric B and metric A are back wit the rest of the metrics Apprecite your advice and guide.
