Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I have a more complicated scenario that I have recreated using the simplified example below.
Setup:
The problem
I would like to get the result of table 4 above, i.e. 2 records, but also with the Pi colum.
Is that possible?
My guess is that some kind of cross-join or auto-exists causes this behavior.
Is there any way to solve this? Something like measure Pi = Calculate(MAX (3.1415), ...TREATASFIXEDVALUE)... or similar?
Any input would be appricated
/Erik
Solved! Go to Solution.
If there are no relationships, PBI creates a cross join between the attributes. You can counteract this by creating a measure that will return non-blank for the rows you want to see and blank otherwise. Then you just filter the visual by that measure (using Filter Pane). The condition should be "is not blank."
If there are no relationships, PBI creates a cross join between the attributes. You can counteract this by creating a measure that will return non-blank for the rows you want to see and blank otherwise. Then you just filter the visual by that measure (using Filter Pane). The condition should be "is not blank."
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
82 | |
55 | |
40 | |
20 | |
12 |