I have attached the pbi file, where for Forecasted Payment measure, at the row level values are correct, but for the total value is wrong.
I know it is a common problem, and can be solved using HASONEVALUE(‘Date’[Date].[Month]) and then creating two seperate formulas for total and row level calculations. However , I am not able to get the total calculation right.
Also i want to see only the current month and future dates in my table. In the current table (PBix attached), I am able to see Values for September only if I display August, but I only want September(current month) and future.
Can some one help?
ch.pbix (151.0 KB)