Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi,
Sorry for reposting, But I had to do it. I really need clarity on the solution.
This is follow up from this thread:
https://community.fabric.microsoft.com/t5/Desktop/How-to-calculate-sum-of-multiple-similar-values-ba...
Problem:
I have values coming from Multiple same Months, if I select multiple Name tag using the Slicer.
How to calculate the sum of December, January, February seperately/collaboratively :
Also, there is a Name column with multiple values, For example: abc, xyy. So Even if I select multiple values, abc and xyz from the slicer for the January month, The total value should be = Sum of all Jan of abc + Sum of all feb xyz.
I'll share two files, One with the sample data and other with the options for the slicer here:
Sample Data:
https://drive.google.com/file/d/1nHU5jecaHeEhbuC6CsG5WGJ4ZucfF8Cy/view?usp=sharing
Slicer Data:
https://drive.google.com/file/d/1gei1Kv7AwzewaJqRyVllP5gM4olC91R4/view?usp=sharing
Now the expected data would be:
If I select tag, FCN2!PGM.RS01.PM01001.SUM.HMI_SUM.SUM(1) For January, 2023, It has to return Sum as total of these two values, i.e : 1312 + 2188 = 3500
I'm sharing the link to the .pbix file, You will find all the measures here.
https://drive.google.com/file/d/1u-pxe5mnxj31IAVFAZ50XKTdMBKTnzJX/view?usp=sharing
All required documents are provided here.
Please someone let me know if this is possible. Thank you for all the support.