Forum Discussion
Create Visual on frontend measures
Hi, rajendraongole1
I am in favor of your approach.
And I would like to share some additional solutions below.
Hi, Anonymous
I am glad to help you.
According to your description, you want to create bar type chart on count of these pass and fail values?
If I understand you correctly, then you can refer to my solution.
Since you didn't give specific test data, I created a simple dataset based on your description and tested a simple example, so I hope this helps.
Dataset:
Create a Measure calculation Pass or Fail:
PassOrFail =
SWITCH (
TRUE (),
ISERROR ( SUM ( 'Score'[Score] ) ), "Error",
SUM ( 'Score'[Score] ) >= 60, "Pass",
SUM ( 'Score'[Score] ) < 60, "Fail"
)
Based on this logical Measure, create a table for counting the number of passes or failures via New Table:
PassFailCountTable =
SUMMARIZE (
ADDCOLUMNS ( 'Score', "PassOrFail", [PassOrFail] ),
[PassOrFail],
"Count", COUNTROWS ( 'Score' )
)
Apply the newly created table to the bar chart:
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
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.
Thanks for your detailed solution. I tried on PowerBI Desktop, data from excel it is working fine. Unfortunately I don't have access to create table on frontend is there any other way to do it ?