Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, Community
I have a fact table "Range" (whole numbers) like the below example. The values start from 0 and end with 2 billions.
There is only a couple of thousand unique values for each range, but the gaps between the previous and current range do not have any logic.
Requriement:
The user must be able to type in any values as a range he wants to check. The system must be able to accept the exact input, even if the exact values are not present in the table.
So far I created 2 DISTINCT tables, 1 for RangeFrom, 1 for RangeTo, with no relation to FACT. I use them as slicers to a table visual. One slicer is "less than or equal to", the other is "greater than or equal to". I have a measuer that calculates resulting scenarios with 3 options: "included", "excluded", "partial".
Due to the big diversity of values i can't create any underlyig table(s) that would include all possible values. What IF parameter is also not an option for the same reason.
Therefore, I am stuck with the following result:
Is there any way to achieve the deisered result?
Or, to narrow down the topic - is there any way to pass on the exact value set by the user into a measure?
Your ideas will be much appreciated!
Thank you in advance
@ElenaGrom Could you create a disconnected table like below and use it in a range slicer? Then adjust your measure to respect the range?
Table = GENERATESERIES(1, 2000000000,1)
Hello, @Greg_Deckler
Thank you for the offered option!
From the BI desktop I tried to create the GENERATESERIES table, but due to the numbers diversity in the source (0 -> billions) I ended up with "out of memory" message.
I think, this is not an option for my case, or is there a way to optimize?
Thank you in advance!
User | Count |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |