Measure based on a column ignoring few other column
Hello Community, I have a chart to display the price values for each country (drill down to entity level) based on the years selected in the slicer. Another slicer will have the list of categories. The request here is 1) Graph to show only the differences that are matching the criteria. for example: if "100-200" is selected in the the difference slicer then the graph should display the countries that are having differences between 100-200 only for the year selected or maximum of the years (in case multiple years are selected). 2) Show the difference value in the tooltip only for the maximum year. The difference value should be sum of the difference values of the entities in that country (hence the drill down). Please can someone share thoguhts on how to achieve this? below is the sample data. Client Country Entity Year Price Maximum Price Difference A India Entity 3 2020 854 975 121 A United Kingdom Entity 4 2021 441 600 159 A United States Entity 5 2022 115 636 521 A India Entity 3 2020 619 519 -100 A United Kingdom Entity 4 2021 233 759 526 A United States Entity 5 2022 687 903 216 B Spain Entity 1 2020 100 152 52 B Australia Entity 1 2021 100 328 228 B New Zealand Entity 1 2022 220 545 325 B Spain Entity 2 2020 400 703 303 B Australia Entity 2 2021 300 800 500 B New Zealand Entity 2 2022 453 900 447
Dax Help
Hi Team, I have requirement where SSRS report has fixed current year values , previous year values and the variance of both. I have now got requirement where to in Power BI report and it should no longer be only a static this year vs last year comparison, but instead allows an adjustable time period (ex: last x weeks/months to previous x weeks/months, this period to same period last year, etc.). Please suggest. Thanks, PrathyCreate Calculated Column for new security trades which shows either current holdings, buys, sells
Hi Guys - newbie here, i am trying to add a column which identifies new trades between two dates (current week and prior week) with the goal to calculate the total value of new trades , sells, and existing holdings. My data set looks something like this (Type of Holding is what I want the calculated column to look like) Link to sample dataset: https://docs.google.com/spreadsheets/d/e/2PACX-1vQQCHpm7AAomMcuPlExXjY3tYnj7WzLkiZXfPUvL6FHtzMUc-untTIlfSNzMNBIL9BLZSbvaNXu7NVG/pubhtml I would like to use this column to track the changes in face value using a decomposition tree (something similar to the below example).YTD showing two different values
Hi all, I have two reports where I use the same YTD dax measure, but the result is really different. On the 1st table the YTD is giving the running total, but on the second table it seems to calculating avg? Which one is correct? Measure: Net Churn - 30D% YTD = CALCULATE([Net Churn - 30D%], DATESYTD('🔎Calendar'[Date])) Measure: CHURN%_YTD = CALCULATE([NET_CHURN%], DATESYTD(monthly_churn_db_dates[DATE_KEY])) Thanks a lot!
