Forum Discussion

MiKeZZa's avatar
MiKeZZa
Post Patron
9 years ago
Solved

Create abberanding total

Is it possible to create an abberanding total in a matrix? This for bookkeeping purpopes?   What I have now is (red is wrong):   Revenues:     Revenue 1                  1.000     Revenue 2    ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    hi MiKeZZa

     

    you can create a new measure to obtain this result:

     

    ValueRV =
VAR REVENUE =
    CALCULATE ( SUM ( Table1[Value] ), Table1[Type] = "REVENUE" )
VAR COSTS =
    CALCULATE ( SUM ( Table1[Value] ), Table1[Type] = "COSTS" )
RETURN
    IF (
        HASONEVALUE ( Table1[Type] ),
        CALCULATE ( SUM ( Table1[Value] ) ),
        REVENUE - COSTS
    )

    And Use it in values Section in Matrix Visual.

     

     

     

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

hi MiKeZZa

 

you can create a new measure to obtain this result:

 

ValueRV =
VAR REVENUE =
    CALCULATE ( SUM ( Table1[Value] ), Table1[Type] = "REVENUE" )
VAR COSTS =
    CALCULATE ( SUM ( Table1[Value] ), Table1[Type] = "COSTS" )
RETURN
    IF (
        HASONEVALUE ( Table1[Type] ),
        CALCULATE ( SUM ( Table1[Value] ) ),
        REVENUE - COSTS
    )

And Use it in values Section in Matrix Visual.

 

 

 

MiKeZZa's avatar
MiKeZZa
Post Patron
9 years ago

This works like a charm! Thank you!