Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Visual showing duplicates in calculated columns

I wanted to show the frequency of absences of a person in the report, so I calculated the count of absence based on week, month and year. The problem is, if there is a week that person has more than 2 absent, and the other week the person has less than 2 absent, the grid is showing both "Y" and "N". Is there a way that if there is a "Y" in the twice a week column, don't show "N" in the grid with the same person?

powerbi.PNG

5 REPLIES 5
Anonymous
Not applicable

Is there a way if this person has "Y" in twice a week column, we don't show rows with "N" of the same column.  Everybody should only has one row in the grid.

What if you created the copy of your table in query editor and then perform Group by "Student Name" and get max of "Twice in a week"?

pbi6.PNG

Hi @Anonymous ,

 

Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Anonymous
Not applicable

Can you post a copy of your source data and the formulas for the calculated fields?

Anonymous
Not applicable

wth.PNGCOUNT.PNG

The weekly count: return a number of the how many times that person absent in that week

Twice a week: Is the person absent more than twice a week? Yes→"Y", No→"N"

So if the person has 1 absence in one week, and 3 absences in the other week, the visual would show both "Y"and"N"

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.