cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
andra2
Frequent Visitor

drill through date filter - please, it is urgent

hello,

 

I am having this below measure that is showcasing the commission for a particular month selected in the main page, using the Invoice Breakdown'[Date] column . Now, in the drill through page I want to display the totalytd of this measure for the selected month starting with november, when the fiscal year starts.

Commission / Rep =
SUMX (
    VALUES ( 'Invoice Breakdown'[placementid]),
    CALCULATE (
        CALCULATE (
            SUM ( 'All Sales'[Consultant Daily Commision] ),
            TREATAS (
                VALUES ( 'Invoice Breakdown'[placementid] ), 'All Sales'[placementid]
            )
        ) * SUM ( 'Invoice Breakdown'[Weekdays Count])
    )
)
 
Do you know how can I achieve this?
 
many thanks
1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @andra2 ,

 

Try the following code:

 

 

 Commission YTD = 
    TOTALYTD (
            [Comission / Rep],
            'Invoice BreakDown'[Date],
            "11/30"      
        )

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

4 REPLIES 4
MFelix
Super User
Super User

Hi @andra2 ,

 

Try the following code:

 

 

 Commission YTD = 
    TOTALYTD (
            [Comission / Rep],
            'Invoice BreakDown'[Date],
            "11/30"      
        )

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



andra2
Frequent Visitor

It worked using 11/01

Glad to know, that value is regarding the date you want to use has your fiscal year start.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



andra2
Frequent Visitor

It worked using 10/30

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors