Forum Discussion
Aggregate a measure after Filtering
Everytime I try to copy/paste the data and post the reply I get an HTML error. So, here's an attempt a delimited list:
Region,Group,Month,Variance
1,A,Apr-21,"($817,554)"
1,A,May-21,"($1,013,666)"
1,A,Jun-21,"($328,526)"
1,B,Apr-21,"$231,961 "
1,B,May-21,"$171,879 "
1,B,Jun-21,"($99,629)"
1,C,Apr-21,"$111,776 "
1,C,May-21,"$6,153 "
1,C,Jun-21,"$304,564 "
1,D,Apr-21,"$110,964 "
1,D,May-21,"($24,477)"
1,D,Jun-21,"($22,846)"
1,E,Apr-21,"($157,251)"
1,E,May-21,"($60,183)"
1,E,Jun-21,"($60,183)"
1,F,Apr-21,"($1,567,083)"
1,F,May-21,"$201,826 "
1,F,Jun-21,"$33,638 "
Hi,
Share the link from where i can download your PBI file.
You have selected 3 months in the slicer. How does one calculate variance for 3 months?
It would be the sum of the monthly variances (included in the dataset) in total, then check if it is negative or not.