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.
m3tr01d's avatar
m3tr01d
Icon for Continued Contributor rankContinued Contributor
5 years ago

With your first picture (showing Total Expenses column)
You can see that 
Total Openings - Total Expenses < 0
So Total Payback si not showing because you explicitly 
request Total Openigs - Total Expenses to be greather than 0 

TotalPayback = IF([TotalOpenings]-[TotalExpenses] >0,[TotalOpenings]-[TotalExpenses])

 

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

so how should i modify or alter this measure to get the total of column