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.
Hi all,
I have a matrix shown below and I am trying to create a measure or filter which compares each column and if there are no changes in my date columns then show blank for that specific row.
I ONLY want to be able to see rows that have different values across each date column.
EXAMPLE: the last row shows 'Brownish' for Dec-22 and 'Red' for the rest of the columns. I would want to keep this row visible as it has changes. The rest of the rows are identicial therefore can be blank.
Can someone explain how this could be done?
Happy to attach the data set if needed. Thank you. (the blue shape is blocking sensitive data)
Solved! Go to Solution.
create a table:
Then take the count of category and once again the distinct count is greater than one
I will appreciate if you give a like to my answers and mark the solution as accepted if that works for you and answers your question.
@olgad
That didn't quite work for me.
So using my table above I have only 1 row that has changes. It does't seem to be showing that. It's counting all the distinct rows (9 rows)
Check if you are using a distinct count as a filter from the new table "summary", if you are summarizing there the correct column (the one with values)
Hope thats clear - I am using the DistinctCount from the table 'changes'
One cannot see the what you are defining as distinct count
let me send you my file may be you see the difference, because if step one worked then step 2 is based on that measure which i named as "distinct count" in first step and reused in summary table.
send your file over and ill take a look 🙂
I saw your file and did the same but still did not work.
Note: I have 9 unique rows as you can see in my first screenshot. But after I show only changes rows I have 1.
I cannot see 1 in the card I see 9
What happens when there is more than 1 row under the same Risk ID?
Ok, then we have differences in data structure. It doesnt matter you have 9 i have 5. in the end i see 3 not 5. so, check whats different on your side in data structure. Or if you can send me your file then i can solve it.
Okay I have sent you my file in a private message
the final word is [DistinctCount]) as per your table below.
Okay send over your file
Can you attach a snapshot? Where i can see the calculation you are doing and the result?
@olgad
Thank you for the solution - that seemed to work!
How would I be able to create a Card to count the number of rows that contain changes?
create a table:
Then take the count of category and once again the distinct count is greater than one
I will appreciate if you give a like to my answers and mark the solution as accepted if that works for you and answers your question.
Hi there,
supposedly you have such data structure:
Create a measure:
Hope that helps.
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |