Forum Discussion

jrscaletta's avatar
jrscaletta
Icon for Helper II rankHelper II
7 years ago
Solved

SUM GROUP BY PERSON and LABOR DAY

Hi all.   I have this structure: CALENDAR table: Date Labor Day: Shows 1 if is labor day TASK table: Userid Task Date Hours USERS table: Userid Username RESERVEDTIMEbyUser TABLE Userid Expecte...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi jrscaletta ,

     

    After going through your pbix. I did the following

     

    1. Created a measure

                                        TotLabourDay = SUM(Calendario[LaborDay])

     

    2. Replaced the field in the Card Visual with this.

     

    3.  Created another measure

         

    TotByUser = CALCULATE(
                SELECTEDVALUE(PrevisionDedicacion[Expected h support]) *
                             [TotLabourDay]
                       )
     
    Added this measure to your table visual.
    4. In the table visual set the visual filtering to Hours is Not blank
     
    Cheers
     
    CheenuSing 

     

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi jrscaletta ,

 

Please post some data and your pbix in the shared  OneDirve or Google Drive and paste the link here to find a solution.

 

What is output expected of the data posted ?

 

Cheers

 

CheenuSing

  • jrscaletta's avatar
    jrscaletta
    Icon for Helper II rankHelper II
    7 years ago

    Hi Anonymous 

     

    Thanks for your reply. I'm going to to explain better and attach PBIX sample file.

     

    The dashboard, now, shows this:

     

    As you can see, I have 261 labors day selected by date slice.

    Then, in "PrevisionDedicacion" table, I defined that for the user1, the expected hours by labor day are 3,20.

    If I've selectec 261 labor day, how can I show this? (3.20 * 261) for each user?

     

    Thanks in advance :)

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi jrscaletta ,

       

      After going through your pbix. I did the following

       

      1. Created a measure

                                          TotLabourDay = SUM(Calendario[LaborDay])

       

      2. Replaced the field in the Card Visual with this.

       

      3.  Created another measure

           

      TotByUser = CALCULATE(
                  SELECTEDVALUE(PrevisionDedicacion[Expected h support]) *
                               [TotLabourDay]
                         )
       
      Added this measure to your table visual.
      4. In the table visual set the visual filtering to Hours is Not blank
       
      Cheers
       
      CheenuSing 

       

       

      • jrscaletta's avatar
        jrscaletta
        Icon for Helper II rankHelper II
        7 years ago

        It works!! Thanks Anonymous