Help with a measure that I am having a hard time with

[Anonymous]

Hello,

I am having a problem making a measure. The following is what I want to accomplish:

As you can see there are 4 columns. Name and Type are columns in the table but Money is a measure and Divide is the measure I want to accomplish. What Divide measure is supposed to do is look at Type and then divide the money values for Part Type by the money values for the Full Type and then return the values you see in the Divide column.

I'm wondering if this is possible in Power BI and if so please give me some insight on this problem.

Thanks.

[v-shex-msft · Accepted solution]

HI @Anonymous,

Is there any specific filters in 'money' measure? if not, you can try to use following measure to calculate percent between 'part' and 'full':

Measure =
VAR full =
    CALCULATE (
        [Money],
        FILTER ( ALLSELECTED ( Table ), [Type] = "Full" ),
        VALUES ( Table[Name] )
    )
VAR part =
    CALCULATE (
        [Money],
        FILTER ( ALLSELECTED ( Table ), [Type] = "Part" ),
        VALUES ( Table[Name] )
    )
RETURN
    IF (
        SELECTEDVALUE ( Table[Type] ) = "Part",
        DIVIDE ( part, full, 0 ),
        BLANK ()
    )

If above not help, please share some sample data and 'money' measure formula for test.

Regards,

Xiaoxin Sheng