Forum Discussion

eheres's avatar
eheres
Frequent Visitor
4 years ago
Solved

Creating a matrix or table from a measure

Hi All,

 

Im new in Power bi, hope you can help me. I want to create a summary table from a measure because when i remove a dimension (fleet) it repeats the value for all the other dimension.

 

in summary the issue is that i have to calculate the incremental values for each fleet, but the fleets change its owner. So in a normal way i have Current month - prior month. The problem is when i add the owners or sales rep by month.

 

i got the split like total incremental = 0 but by sales rep 5 and -5 i only want the total incremental 

 

please find attached the PBI file

 

https://elementfinancialcorporation-my.sharepoint.com/:u:/g/personal/eheres_elementcorp_com/EXwQACcgTGNDmDyUER2O-lcBUTu6KWmw5Aaa7Gmzag5uVg?e=PciLpS

 

for example

 

 the correct numbers of result are 

 

 

 

Data Protection
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi eheres ,

     

    The link shows 'User not in directory.' and I can't download the pbix file.

     

    I made a sample for testing.

    For aa, you can create a measure like this.

     

    aa = CALCULATE(SUM('Table'[absolut incremental]),'Table'[Sales Rep Sic ]="aa")

     

    The same goes for ag and cc.

     

    ag = CALCULATE(SUM('Table'[absolut incremental]),'Table'[Sales Rep Sic ]="ag")
    cc = CALCULATE(SUM('Table'[absolut incremental]),'Table'[Sales Rep Sic ]="cc")

     

    Then drag the measures into the table visualization along with the [Custom] column.

    Attach the pbix file for reference.

     

    Best Regards,
    Community Support Team_Gao

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi eheres ,

     

    The link shows 'User not in directory.' and I can't download the pbix file.

     

    I made a sample for testing.

    For aa, you can create a measure like this.

     

    aa = CALCULATE(SUM('Table'[absolut incremental]),'Table'[Sales Rep Sic ]="aa")

     

    The same goes for ag and cc.

     

    ag = CALCULATE(SUM('Table'[absolut incremental]),'Table'[Sales Rep Sic ]="ag")
    cc = CALCULATE(SUM('Table'[absolut incremental]),'Table'[Sales Rep Sic ]="cc")

     

    Then drag the measures into the table visualization along with the [Custom] column.

    Attach the pbix file for reference.

     

    Best Regards,
    Community Support Team_Gao

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data