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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
rmeng
Helper II
Helper II

Calculate quarter data based on a month selection

I need help to build a card or a table value when a month is filtered to show the value of all quarter not only the month selected.

 

when I select 2021 September I need the September value that´s easy and correct but for Quarter 3 I need a value summing all 3 months of that quarter.

 

2021-10-12_12-28-19.jpg

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@rmeng 

Use the following measure:

Event Quarter = 
CALCULATE(
    [# Events],
    REMOVEFILTERS('Calendar'[Year Month]),
    VALUES('Calendar'[Year Qtr]])
)
Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

1 REPLY 1
Fowmy
Super User
Super User

@rmeng 

Use the following measure:

Event Quarter = 
CALCULATE(
    [# Events],
    REMOVEFILTERS('Calendar'[Year Month]),
    VALUES('Calendar'[Year Qtr]])
)
Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.