Forum Discussion

tcboutte's avatar
tcboutte
Regular Visitor
5 years ago
Solved

DAX - Multiply by Explicit Row Values

Seems like a simple thing, but am looking for some help! I need to return a value in the "GC Scenario" column equal to the value of column three (94,340.75) times the percentage ("value" - second scr...
Need Help
  • v-cazheng-msft's avatar
    v-cazheng-msft
    5 years ago

    Hi, tcboutte 

    You can try a Measure like the following.

     

    GC Scenario =

    VAR charges_sum =

        CALCULATE ( SUM ( Financial[Charges] ), DISTINCT ( Financial[Person] ) )

    VAR val =

        CALCULATE (

            ROUNDUP ( MAX(Percentage[Value]) , 2 ),

            FILTER ( Percentage, Percentage[Date] = MAX ( Percentage[Date] ) ),

            TREATAS ( VALUES ( Financial[Person] ), Percentage[Person] )

        )

    RETURN

        charges_sum * val

     

    Here is the pbix.

     

    Best Regards,

    Caiyun Zheng

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-cazheng-msft's avatar
v-cazheng-msft
Community Support
5 years ago

Hi, tcboutte 

You can try a Measure like the following.

 

GC Scenario =

VAR charges_sum =

    CALCULATE ( SUM ( Financial[Charges] ), DISTINCT ( Financial[Person] ) )

VAR val =

    CALCULATE (

        ROUNDUP ( MAX(Percentage[Value]) , 2 ),

        FILTER ( Percentage, Percentage[Date] = MAX ( Percentage[Date] ) ),

        TREATAS ( VALUES ( Financial[Person] ), Percentage[Person] )

    )

RETURN

    charges_sum * val

 

Here is the pbix.

 

Best Regards,

Caiyun Zheng

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

tcboutte's avatar
tcboutte
Regular Visitor
5 years ago

That did the trick for us, thank you!!