Forum Discussion
Create Visual on frontend measures
Here is data in WorkUnit Table and PF is measure created on frontend based on logic.
| Work Units | Class Code | PF |
| 2P006 | 110 | Pass |
| 2A010 | 114 | Fail |
| 2A011 | 105 | Fail |
| 2J012 | 109 | Pass |
| 2A013 | 105 | Fail |
| 2W014 | 105 | Pass |
| 2M015 | 110 | Fail |
| 2A016 | 105 | Fail |
| 2Q017 | 105 | Fail |
| 2A018 | 103 | Pass |
| 2F019 | 105 | Fail |
| 2A021 | 101 | Pass |
| 2A022 | 105 | Pass |
From your suggested answer I don't any 'PassFailTable' ?
Please refer data above and table name, as suggested by Anonymous It worked but I don't have access to create new table on frontend.
Hi, Anonymous
New Table is done in Power BI Desktop as follows:
I don't know the calculation logic of your Measure CodePF.
In my example, my Measure PassOrFail is your Measure CodePF, you just need to change the corresponding parameter in the DAX formula of New Table:
PassFailCountTable =
SUMMARIZE (
ADDCOLUMNS ( 'WorkUnit', "PassOrFail", [CodePF] ),
[CodePF],
"Count", COUNTROWS ( 'WorkUnit' )
)
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.