Forum Discussion

Anmolgan's avatar
Anmolgan
Icon for Post Prodigy rankPost Prodigy
5 years ago

Excel dump showing something else while Power BI visual shows something else

I have never seen this issue, below is the DAX measure that I am using it gives me a quantity of 419793 on the visual level but on the excel download it gives me 619783 not sure why and how this is happening.

 

Pending Quantity Logic =
var pending= CALCULATE(SUM('Pending Order'[PendingQty]), DATESINPERIOD('Pending Order'[CustomerPODate], TODAY(), -31, DAY))


VAR maxdatepending = CALCULATE(max('Pending Order'[CustomerPODate]),ALL('FWS Report for National'[Sold-to party.Sold-to party Level 01.Key],'FWS Report for National'[Sold-to party.Sold-to party Level 01]))

VAR maxminus30 = maxdatepending-30

VAR pendingorder = CALCULATE(sum('Pending Order'[PendingQty]),'Pending Order'[CustomerPODate]>=maxminus30,'Pending Order'[CustomerPODate]<=maxdatepending)

return
if(pending=BLANK(),pendingorder,pending)
//pendingorder/1000
Need Help
Show and Tell

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi  Anmolgan  ,

    1. The data you export through Excel is detailed data, which may also contain repeated data, and the data in the visual object is summrize data, which is aggregated.

    2. You can check whether Sum is turned on in a field on the visual object, which leads to aggregation and reduces data.

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.