Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys,
Morning!
I am working on Sales data and the data has Open Order Sales by Doc_date and Doc_due_date in the MCS_PowerBI_Fact table.
Requirement: I am looking for an Open Order Sales visual by Doc_due date. - Currently, I am getting open order sales by Doc_date
Measures I am using
The following measure was for currency conversion,
And, If I change the relationship to Doc_Date to Doc_Due_Date then the sales figures are effecting(Which was sales figures are getting wrong)
Any help can be appreciated
Sorry--copy/paste error:
OpenOrderSales = CALCULATE(SUM([OpenOrderSalesAUD]), DISTINCT('MCS_POWERBI_FACT'[DocDueDate]), USERELATIONSHIP('MCS_POWERBI_FACT'[DocDueDate],'Master Calendar'[Date]))
I tried it - But, the measure output was the same as my last measure as mentioned in the post.
If you see the Doc_Date and Doc_Due_Date columns
The requirement was, we need to extract only Doc_Due_date if Doc_Due_date was in the Current month.
The OLD_Open Order Sales measure was working but giving us all open order Sales - where we need only present and future months open order sales.
Hi @Sai_Kumar ,
Consider using Crossfilter() to change the cross filter direction or change it manually in the relationship view to check whether it works.
Plesae refer: Bi-directional relationship guidance
If it still has the same issue, you can consider sharing a simple sample file without any sentive information for further discussion.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Try:
OpenOrderSales = CALCULATE(SUM([OpenOrderSalesAUD]), DISTINCT('MCS_POWERBI_FACT'[DocDueDate]), USERELATIONSHIP('Master Calendar'[Date]))
--Nate
Hi Watkinnc,
Thanks for considering!
I tried the way as you said
The error follows-
Too few arguments were passed to the USERELATIONSHIP function. The minimum argument count for the function is 2.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.