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
Filtering Table Data Based on certain conditions
Hi all, Seeking help on the below. In a table visual, I have data for WW45 and WW46 across various categories. I want to display data only when either the remarks or the fluctuation week-over-week (WoW) is not empty. If either the remarks or the WoW is empty, the corresponding data should not be shown. Currently, I am unable to achieve this, as I have data for each WW.
Need Help Adding Text Slicer to Table in Power BI
Hi everyone, I'm working on a project in Power BI and need a table that changes its values based on three different slicers. The slicers I need are as follows: First Slicer: Contains text values Second Slicer: Contains numeric values (this slicer is set up correctly and works fine) Third Slicer: Contains a set of measures written with a calculated group (this slicer is also set up correctly and works fine) My problem is adding the first slicer to the table. I'm not sure how to add this text slicer to my table so that the values are filtered based on the selections from the text slicer. Could anyone guide me on how to do this? Any advice or practical examples would be greatly appreciated. Thank you very much
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?
