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.
Hello!
I've been having a problem with a specific visualization that I would need some help with.
I also have to have a lot of filters within the measures to get the exact data I need.
I have a Table1 that looks kind of like this:
ID_EMP | ID_NUM1 | ID_NUM2 | VALUE | SLICER |
1 | 101 | 20 | 123,40 | |
1 | 102 | 20 | 23,40 | |
1 | 103 | 20 | 2,30 |
|
1 | 104 | 20 | 2,10 | 2,10 |
1 | 106 | 21 | 12,30 | |
1 | 107 | 21 | 123,30 | |
1 | 108 | 21 | 122,40 | |
1 | 109 | 21 | 200,00 | |
1 | 110 | 22 | 211,00 | |
1 | 111 | 22 | 12,40 | |
1 | 112 | 22 | 123,10 | |
1 | 113 | 22 | 11,20 | |
2 | 101 | 20 | 133,20 | |
2 | 102 | 20 | 32,40 | |
2 | 103 | 20 | 1,20 | |
2 | 105 | 21 | 3,10 | 3,10 |
2 | 106 | 21 | 22,10 | |
2 | 107 | 21 | 134,20 | |
3 | 101 | 20 | 122,10 | |
3 | 102 | 20 | 11,30 | |
3 | 103 | 20 | 2,10 | |
3 | 104 | 20 | 2,40 | 2,40 |
3 | 106 | 21 | 11,40 | |
4 | 103 | 20 | 2,10 | |
4 | 104 | 20 | 3,20 | 3,20 |
4 | 106 | 21 | 13,10 |
The slicer column is a measure.
SLICER = IF(CALCULATE([VALUE],(Table1[ID_NUM1]=105 && Table1[ID_NUM2]=21) || (Table1[ID_NUM1]=104 && Table1[ID_NUM2]=21))>0,[VALUE],BLANK())
In my visualization I have a table like this:
ID_EMP | NAME | VALUE_1 | VALUE_2 |
1 | John | 123,40 | 2,10 |
2 | Emma | 133,20 | 3,10 |
3 | Tom | 122,10 | 2,40 |
4 | Bob | 3,20 |
VALUE_1 = calculate([value],Table1,Table1[ID_NUM1]=101,Table1[ID_NUM2]=20)
VALUE_2 = calculate([value],Table1,(Table1[ID_NUM1]=105 && Table1[ID_NUM2]=21) || (Table1[ID_NUM1]=104 && Table1[ID_NUM2]=21))
I don't want to show rows with missing VALUE_1 data. So I filtered the table that VALUE_1 is not blank.
ID_EMP | NAME | VALUE_1 | VALUE_2 |
1 | John | 123,40 | 2,10 |
2 | Emma | 133,20 | 3,10 |
3 | Tom | 122,10 | 2,40 |
Now I need to add a Slicer for the VALUE_2 measure. So I created the slicer measure/column, but when I want to filter my table by the slicer values it shows an empty table, because of the table filter VALUE_1 is not blank. If I disable the filter the slicer kind of works, but it doesn't show the VALUE_1 data, it only shows VALUE_2 data and it shows the employees I don't want included.
I know what the problem is but I don't know how to solve it.
What I want to achieve is, that I can display four measured values for each employee in a table, one measure can’t be blank, and I want to have a slicer for the second measure, but all values have to be shown in the rows. If it makes sense?
Can this be done?
Kind regards,
L
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |