Total row not showing the correct amount
Hello i have this issue, i have a Measure called $ / Ton $ / Ton = SUM(BD[MXN]) / SUM(BD[Movidas]) Also this measure called Impacto: Impacto = SUMX( VALUES('BD'[Ruta]), VAR VolumenAuto = CALCULATE(SUM('BD'[Movidas]), 'BD'[Transporte] = "Auto") VAR VolumenFFCC = CALCULATE(SUM('BD'[Movidas]), 'BD'[Transporte] = "FFCC") VAR CostoPorTonAuto = CALCULATE([$ / Ton], 'BD'[Transporte] = "Auto") VAR CostoPorTonFFCC = CALCULATE([$ / Ton], 'BD'[Transporte] = "FFCC") RETURN IF(VolumenAuto > 0 && VolumenFFCC > 0, ROUND((CostoPorTonAuto - CostoPorTonFFCC) * VolumenAuto, 0), 0 ) ) In the Rows the value of Imacto is correct and if i compare it with the excel data is all good but the problem is in the total is not showing the correct amount In PBI in Excel; what am i doing wrong in the Impacto Measure? thanks in advance.
Read slicer values, retrieve corresponding table column values and use them to check existence
Hi all, I am trying to retrieve a column values based on the selected single/multiple slicer values and use those data to check their existence in the other table. Let me put this out clearly. There are two tables i.e., Calendar and Employee data. The calendar has the following columns i.e., fiscal year, fiscal year period, date. Adding the screenshot below. Calendar table: The Employee table has Name, Location, Joined Date. Employee table: The slicer in the Power BI dashboard is added with the 'Fiscal year period' column from 'Calendar' table. If the user selects a particular fiscal period or multiple fiscal periods, the corresponding dates from the Calendar table have to be read in a dax calculation and check the existence of those date values in the Joined date column in the table 'Employee'. For instance, if the user selects 2025 P3 and 2025 P4 from the slicer, then the corresponding dates from 3rd March to 4th May have to be read and check if any of those values exist in the column from other table i.e., in Joined date from Employee table. Could you please help me with a dax calculation/measures for this scenario? Any suggestions will be appreciated. Thanks! Microsoft EnterpriseDNA
I can’t use measure as a chart legend to categorize the data
Hello! I have a dataset like this: Date Client Total Sales Sales Prev Diff Sales MRR Measure 2024/January A 200 200 New 2024/February A 500 -200 Lost 2023/January B 100 New 2024/January B 650 150 Reactivation 2024/February B 150 -150 Lost 2023/December E 11885 New 2024/January E 6265 11885 -10670 Reduction 2024/February E 1515 -1215 Lost 2024/March E 6270 6970 Reactivation 2024/April E 64850 6990 7880 Expansion 2024/May E 3650 14850 -11700 Reduction I have written a DAX code as a measure. The code is as follows: MRR Measure = if([firstD]=1,"New", if(and([Total Sales]>=0,[Sales Prev]=0),"Reactivation", if([Diff Sales]>=0,"Expansion", if(and([Total Sales]=0,[Sales Prev]<>0),"Lost", if([Diff Sales]<0 , "Reduction"))))) and the code for the Different Sales: Diff Sales = [total sales]-[sales prev] I want to add a bar chart based on this different sales value and the date. It gives me something like this: I want something like below, but because I have written a measure I can’t move it to the legend field in the chart. What should I do?
