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 ?!?!
2 ACCEPTED SOLUTIONS
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 ) )
)
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 ) )
)
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Power BI Monthly Update - January 2026
Check out the January 2026 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
