Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
When I am trying to sum up the count I get 2 for John on Feb 18th but actually want that value to be 1. Is there a way to make it so that the first date comes out as 1 on the NoDupCount column and then 0 for any of the other counts that fall on that date. Looking for a calculated column solution and have looked everywere online and couldn't figure it out.
Solved! Go to Solution.
Hi @Anonymous
This is one of the way to do this:
1.Create a indx column.
2. Creata Your new column with this formula: NoDUpCount = IF( CALCULATE(MIN(Table1[Index]), FILTER(Duplicate,Table1[Name]= EARLIER(Table1[Name]) && Table1[Date]= EARLIER(Table1[Date]))) = Table1[Index], Table1[Count],0)
Thanks
Raj
Hi,
Why do you want a calculated column solution. With a measure, it is a simple solution.
=DISTINCTCOUNT(Data[Count])
or
=MIN(Data[Count])
Drag Name and Date to the row labels of your visual.
Hi @Anonymous
This is one of the way to do this:
1.Create a indx column.
2. Creata Your new column with this formula: NoDUpCount = IF( CALCULATE(MIN(Table1[Index]), FILTER(Duplicate,Table1[Name]= EARLIER(Table1[Name]) && Table1[Date]= EARLIER(Table1[Date]))) = Table1[Index], Table1[Count],0)
Thanks
Raj
Thank you for the answer. I think it has answered my question for now so I will accept this as my solution but I will keep testing to see if the data turned out how I wanted. Thank you again for helping me out!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |