Count occurrences ????

[Anonymous]

I have a table which contains all possible values eg: 

And I have another table : 

I need to count how often each value appears like this: 

But how do I realize this ?!?!

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure whether I understood your question correctly, but please check the below picture and the attached pbix file.

Occurrences: =

VAR currentvalue =

MAX ( 'Values'[Values] )

RETURN

IF (

HASONEVALUE ( 'Values'[Values] ),

CALCULATE ( COUNTROWS ( Data ), FILTER ( Data, Data[Column1] = currentvalue ) )

+ CALCULATE ( COUNTROWS ( Data ), FILTER ( Data, Data[Column2] = currentvalue ) )

+ CALCULATE ( COUNTROWS ( Data ), FILTER ( Data, Data[Column3] = currentvalue ) )

)

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure whether I understood your question correctly, but please check the below picture and the attached pbix file.

Occurrences: =

VAR currentvalue =

MAX ( 'Values'[Values] )

RETURN

IF (

HASONEVALUE ( 'Values'[Values] ),

CALCULATE ( COUNTROWS ( Data ), FILTER ( Data, Data[Column1] = currentvalue ) )

+ CALCULATE ( COUNTROWS ( Data ), FILTER ( Data, Data[Column2] = currentvalue ) )

+ CALCULATE ( COUNTROWS ( Data ), FILTER ( Data, Data[Column3] = currentvalue ) )

)

[Anonymous]

@Jihwan_Kim How can I get the total?

[Jihwan_Kim · Accepted solution]

Hi,

please check the attached pbix file.

[Anonymous]

Thank you so much !

[Anonymous]

You're a hero