Problem with the grand total when using FIRSTNONBLANK function
Hi, I'm having a fact table, where from several reasons there are stored repeated numeric values in one column. I need each value only once, so instead of using SUM('Fact Sales Order'[Quantity]), I'm using a workaround FIRSTNONBLANK('Fact Sales Order'[Quantity], 1). It works perfect for me, but the problem with this solution is that when I'm trying to create a pivot table in excel, the grand total appears to be zero, even though the values inside the table are correct and there are no zeros. Is there a way to fix this, or maybe there is an alternative function that I can use for such purposes? I would appreciate any advice Thanks in advance!Need help with DAX Formulation for sum using equality operator Date columns
Hi, I have an input method format as shown below in the image(which is obtained through powerapps) Where the input date has a 'one to one' relationship with the dim date table Illustration Purpose: This is how values are stored in the dashboard Dim input table DAX Formula By using the above formulation I want to achieve the following output: But I get this as my output Am I missing out something in the formulation?
