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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Create Measure based on text columns in table and parameters

I want to create a measure based on parameters. i have a table which contains site type, so based on site type i have to create a parameter. the parameter is then used to create a measure.

eg :

table 1 :

Ticket#,assignment_group,site_type

table 2 :

engineer name,fte count,assignment group

parameter 1 :

value = 7

parameter 2 :

value = 10

 

i need to create a measure where

if site_type = x then parameter1*fte count

if site_type = y then parameter2*fte count

 

i will use the above measure to show in graph,matrix visualization by group name

eg

Assignment_GroupTickets#FTEMeasure I want to createAvg Tickets Per Day
A9972.22212.4625
B9732.22211.44705882
C94833011.42168675
D88122011.0125
E7392209.2375
F3281104.61971831

 

 

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , Assume these two what if parameter with measures p1 and p2 and fte count is a measure too

 

Sumx(values(Table[Assignment_Group]) , if(Table[Site Type]= "X", [P1]*[fte count], [fte count]*[P2]) )

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

brilliant and thanks

amitchandak
Super User
Super User

@Anonymous , Assume these two what if parameter with measures p1 and p2 and fte count is a measure too

 

Sumx(values(Table[Assignment_Group]) , if(Table[Site Type]= "X", [P1]*[fte count], [fte count]*[P2]) )

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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