Forum Discussion

FaisalImam's avatar
FaisalImam
Icon for Helper I rankHelper I
3 years ago

Static Data and specific measures in a matrix/table

Hi Guys,   I have a static table loaded in power bi : metric minimum level maximum level p1 45% 100% p2 95% 105% p3 85% 95%   I have calculated some measures but it has no...
Need Help
lukiz84's avatar
lukiz84
Icon for Memorable Member rankMemorable Member
3 years ago

Can you show some sample data of the other table? (The one where your measures calculate data from...)

FaisalImam's avatar
FaisalImam
Icon for Helper I rankHelper I
3 years ago

It is like incident table 

incnumberactive/inactiveopened closedstate month year 

 

Kind of measures  i have created - 

P2 Resolution Total_Tickets = CALCULATE(COUNT('Incident Data'[Number]),FILTER('Incident Data','Incident Data'[Priority] = "2 - High"),FILTER('Incident Data','Incident Data'[OPENED MONTH] = MONTH(TODAY())))
 
P2 Resolution_Achieved = CALCULATE(COUNT('Incident Data'[Number]),FILTER('Incident Data','Incident Data'[Priority] = "2 - High"),FILTER('Incident Data','Incident Data'[SLA MET]= "Achieved"),FILTER('Incident Data','Incident Data'[OPENED MONTH] = MONTH(TODAY())))
 
Please note , I dont find any relation between static table and measures calculated. Measures are very complext based on filters,state,etc.