Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Lobo1908
Helper I
Helper I

Count occurrences based on lookup table and a category in it

Hi, 

 

I've got a table with bunch of codes. 

Now I need a measure to count those codes but only the one that have a specific condition which is assigned to each code in a lookup table. 

 

My data table looks like that. 

Code 
A1
B1
C1
A1
B1
C1
A1
B1
C1
A1
A1
D1
C1
C1
A1

D1

My lookup table like this

 

CodeCondition 
A1New
B1New
C1Old
D1

Old

 

And for example I want to count only the one that have 'New' as Condition in the loopu table 

 so the results hsoulkd be:

A1 - 6

B1 - 3

 

Could nayone support please 

 

2 REPLIES 2
HotChilli
Super User
Super User

create a relationship between lookup table and the main table (on code).

Drag Code field from the lookup on to a table visual, drag code from the main table on to the same visual.  Make the second one a Count aggregation.

Put Condition from the lookup table in a slicer

Hi @HotChilli ,

I know how to present those values in a table or matrix. 

I require a measure for further calculations

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.