Hello Forum Members,
I've a scenario where I've created two measures.
1. To calculate the figures for individual line items.
2. To get the correct totals of those line items.
My query is - I'm getting incorrect totals in my measure number one so then I created another measure so I can have correct grand total figure using the SUMX( SUMMARIZE() ) function. When I create two individual measures I get the correct totals figure but when I try to incorporate this within the same measure using Variables I get highly vague and incorrect results.
I'm attaching the screenshot where Measure 1 shows the correct figure for individual line items but showing incorrect totals and Measure 2 showing the correct grand totals.
I'm also attaching the PBIX File for the reference.
Please help in finding out how I can incorporate this two measures within one single measure rather than having two separate measures.
Thanks & Warm Regards,
Used for anything related to the new Power BI Desktop and Service tools
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 0 guests