Forum Discussion
FaisalImam
Helper I
Helper IStatic 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 relation with above table :
- p1 total , p1 achieved , p1%
- p2 total, p2 achieved, p2%
- p3 total , p3 achieved , p3 %
I need to create a table matrix like :
| metric | maximum | minimum | total | achieved | % |
| p1 | 45% | 100% | p1 total | p1 achieve | p1% |
| p2 | 95% | 105% | p2 total | p2 achieve | p2% |
| p3 | 85% | 95% | p3 total | p3 achieve | p3% |
Please help , Any Dax that can be used ?Need urgently!!
4 Replies
lukiz84Memorable Member
Can you show some sample data of the other table? (The one where your measures calculate data from...)
FaisalImamIt is like incident table
incnumber active/inactive opened closed state 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.
- lukiz84
If you add the key "p1" (and "p2" and so on) in your Incident Data table as a calculated column you can connect those tables.
- FaisalImam
Its not possible because the measures are not row oriented. Not all measure have syntax with P1 ,Px , we could have INX as well