Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

Cannot find the sum of a value column per month per tag

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 :

nishad1092_0-1689915401196.png

 

 


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 

nishad1092_1-1689915256286.png

 

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.

1 REPLY 1
Anonymous
Not applicable

Hi

 

Anyone please support me.

@Ritaf1983 I created another new thread, Could you help me please. ?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.