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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
kumsha1
Post Patron
Post Patron

Column totals in a measure ignoring few filters while considering other filters

It could be simple but i am just not getting this right, any help is much appreciated.

How can i get the highligted total from 2nd table as a seperate measure for 1st table. Only difference is 2nd table doesn;'t have Previous_Day flag.

 

kumsha1_1-1622617724473.png

Cheers,

1 ACCEPTED SOLUTION
kumsha1
Post Patron
Post Patron

Created below measure and it's working fine. 

 

Total MTDPlanValue =
VAR SM = MONTH(SELECTEDVALUE('Table'[CALENDAR_DATE]))
VAR SY = YEAR(SELECTEDVALUE('Table'[CALENDAR_DATE]))
VAR SA = SELECTEDVALUE('Table'[Attribute])
RETURN
CALCULATE(SUM('Table'[MTD_PLAN_VALUE]),FILTER(ALL('Table'),'Table'[CALENDAR_MONTH]=SM && 'Table'[CALENDAR_YEAR]=SY && 'Table'[Attribute]=SA))

View solution in original post

2 REPLIES 2
kumsha1
Post Patron
Post Patron

Created below measure and it's working fine. 

 

Total MTDPlanValue =
VAR SM = MONTH(SELECTEDVALUE('Table'[CALENDAR_DATE]))
VAR SY = YEAR(SELECTEDVALUE('Table'[CALENDAR_DATE]))
VAR SA = SELECTEDVALUE('Table'[Attribute])
RETURN
CALCULATE(SUM('Table'[MTD_PLAN_VALUE]),FILTER(ALL('Table'),'Table'[CALENDAR_MONTH]=SM && 'Table'[CALENDAR_YEAR]=SY && 'Table'[Attribute]=SA))
jaideepnema
Solution Sage
Solution Sage

Hi @kumsha1 ,

Can you share a PBIX with sample data to understand your query better ?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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