Divide Count ifs equivalent to dax

[o59393]

Hi all

How could I get a dax measure like the one below I did in excel?

Here is the table:

Topic	Impact	%
ABC	High	75.00%
ABC	High	75.00%
ABC	High	75.00%
ABC	Medium	25.00%
Test	Low	25.00%
Test	High	25.00%
Test	Medium	50.00%
Test	Medium	50.00%

I tried something like this but it's not working

Count Ifs = 

DIVIDE(
    CALCULATE(
        COUNTROWS('Heatmap'),
        FILTER(
            'Heatmap',
            'Heatmap'[Risk] = EARLIER('Heatmap'[Risk]) && 'Heatmap'[Risk] = EARLIER('Heatmap'[Risk])
        )
    ),
    CALCULATE(
        COUNTROWS('Heatmap'),
        FILTER(
            'Heatmap',
            'Heatmap'[Risk] = EARLIER(Heatmap'[Risk])
        )
    )
)

Please click on the image to see bigger.

Thanks.

[ThxAlot]

PCT = 
CALCULATE( COUNTROWS( Data ) )
    / CALCULATE( COUNTROWS( Data ), ALLEXCEPT( Data, Data[Topic] ) )

[o59393]

Hi @ThxAlot 

I used the dax in the real dataset and got 25% each:

What should happen is: 50%, 25%, 25%, 50%

50% meaning 2 rows out of 4 rows are High

1 out of 4 rows is low

1 out of 4 rows is blank

How can I fix it?

Thanks.

[Jihwan_Kim]

Hi, 

Please check the below picture and the attached pbix file.

It is for creating a new column.

Expected result CC =
VAR _topic =
    COUNTROWS ( FILTER ( Data, Data[Topic] = EARLIER ( Data[Topic] ) ) )
VAR _impact =
    COUNTROWS (
        FILTER (
            Data,
            Data[Topic] = EARLIER ( Data[Topic] )
                && Data[Impact] = EARLIER ( Data[Impact] )
        )
    )
RETURN
    DIVIDE ( _impact, _topic )

[o59393]

Hi @Jihwan_Kim 

I am getting this error highlighted in red:

Any idea why?

Thanks.

[Jihwan_Kim]

Hi, 

is this written for a measure or a calculated column?

My sample solution is, as mentioned above, for calculated column.

Thanks.

[o59393]

Hi @Jihwan_Kim 

Should be a measure. 

Thanks!