How to Display Data by Teacher_ID Only in a Power BI Visual without Being Affected by other Relation

[ginalu]

Problem Explanation:

In the visualized table, even though the complete data in the LESSONN table includes multiple ord_id values and different user_org_id values for the same teacher_id, the visual seems to display data only for a specific user_org_id associated with that teacher_id, instead of showing all data for that teacher_id across all user_org_id values.

I want the visual to ignore user_org_id and display all rows associated with the selected teacher_id.

update : 

When I break the relationship between the LESSONN table and the ORGUSER table, the count returns to normal. However, this visual only uses data from the LESSONN table, so I'm not sure why the related table affects it. I want to know how to count the number of teacher_ids independently, without considering which org_id they belong to, while still keeping the relationship active.

The tables are related through a key that combines teacher_id and org_id."

[Anonymous · Accepted solution]

Hi @ginalu ,

You can try creating a new table that contains only unique teacher_id values. This table will serve as a filter for your visual objects. Then, use DAX formulas to create measures that calculate the required values, which will ignore user_org_id and focus only on teacher_id.

TotalCohort = CALCULATE(SUM(Lessonin[Cohort]), ALLEXCEPT(Lessonin, Lessonin[teacher_id]))

TotalLessonMonth = CALCULATE(SUM(Lessonin[Lesson_Month]), ALLEXCEPT(Lessonin, Lessonin[teacher_id]))

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Uzi2019]

Hi @ginalu 

Yes. If you avoid org_user_id it will show aggregated data. you can use no summarization on lesson_month

or if you just want to display the same information without org_user_id. just change the color of that org_cust_id like below

changed specific column setting make it to similar color as a background.

I hope above tricks would help you!

[ginalu]

Hi @Uzi2019 ,  

I confirmed that I turned off the summarized option, but it still only shows the count for a specific org_id.

For example, I actually have 20 teacher_ids, but in this visual table, it shows only 5 teacher_ids for a certain org_id under the same filter settings.

When I break the relationship between the LESSONN table and the ORGUSER table, the count returns to normal. However, this visual only uses data from the LESSONN table, so I'm not sure why the related table affects it. I want to know how to count the number of teacher_ids independently, without considering which org_id they belong to, while still keeping the relationship active.

The tables are related through a key that combines teacher_id and org_id."

[Uzi2019]

hi @ginalu 

If possible can you share the pbix??? 

please check the filters that are being applied to the table..

take completely new page add all the teacher id n their data and check what it shows??

and if nothing is helping you you can share the pbix via open link..

[Uzi2019]

Hi @ginalu 

You have taken only 3 columns from Lesson table in 1st visual. and in 2nd visual your are pointing Org_id which you have not taken in 1st table visual.

I am not able to understan what is missing , you have not taken org_id in first table. 

can you explain in detail??

[ginalu]

Hi @Uzi2019, thank you for your response. I’ve updated my question description to clarify the details. Could you please review it and let me know if it’s clear.

[Ritaf1983]

Hi @ginalu 

Please provide a workable sample data and your expected result from that. It is hard to figure out what you want to achieve from the description alone.  

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

[ginalu]

Hi @Ritaf1983 , thank you for your response. I’ve updated my question description to clarify the details. Could you please review it and let me know if it’s clear.