Forum Discussion

Islam's avatar
Islam
Icon for Helper V rankHelper V
5 years ago
Solved

A problem with martix total

hey i got i matrix report in power bi project and i got some some measures but one of them doesn't display total in marrix and i dun know why like in the attached photo in totalpayback vlaues ...
Need Help
  • nandic's avatar
    nandic
    5 years ago

    Islam , as mention at the begining, the reason for this os because in total row the difference is in minus and there is no result. The logic is as on detail row, if openings<expense, return 0.
    So in order to have "sum" in totals, you need to use IfHasOneValue.
    Attached file.

    Example:
    TotalPayback New =
    var _filterArea = FILTER('Table','Table'[Openings]>'Table'[Expenses])
    RETURN
    IF(HASONEVALUE('Table'[YearMonth]),
    IF([TotalOpenings]-[TotalExpenses] >0,[TotalOpenings]-[TotalExpenses]),
    SUMX(_filterArea,'Table'[Openings]-'Table'[Expenses])
    )
     
    Regards,
    Nemanja Andic

    Attached file.
negi007's avatar
negi007
Icon for Community Champion rankCommunity Champion
5 years ago

Islam In powerbi, there are many relationships between multiple tables which determines the output. So it is possible that there might be some discrepency in the relationship between tables which resulting in mismatch in the output. I would suggest you to check the relationship between date table and other table which sometime is main cause of error or issue. 

 

Let me know if you need further assistance on this. You may try sharing your powerbi file or some sample data to test it at our end. 

  • Islam's avatar
    Islam
    Icon for Helper V rankHelper V
    5 years ago

    ok i'll check it

  • Islam's avatar
    Islam
    Icon for Helper V rankHelper V
    5 years ago

    I'll try it right now

     

  • Islam's avatar
    Islam
    Icon for Helper V rankHelper V
    5 years ago
    RequiredToPay = IF([TotalExpenses]-[TotalOpenings] >0,[TotalExpenses]-[TotalOpenings])
    this measure is working fine but this one
    TotalPayback = IF([TotalOpenings]-[TotalExpenses] >0,[TotalOpenings]-[TotalExpenses])
    give me the values without totals