Forum Discussion
Summarize measurement calculation
Hi!
My first post 😉
Let me explain my problem for a suggestions.
I do have two tables, connected by user id. in fact is the same table, generated with a summarized function.
I want to analyze the correlation between different products with an AND and OR, in other words, the database looks like,
id product
1 A
1 B
2 A
2 B
2 C
3 C
4 B
4 C
4 D
In the summarized table im selecting A usign a slicer, returning 1 and 2. This will filter the original table id that contain, 1 and 2.
1 A
1 B
2 A
2 B
2 C
I do have a second slicer in the original table, and im selecting B and C.
1 B
2 B
2 C
I created a measurement to count how many products are within the different ids, plottign the results in a table, it will be like,
id number of products
1 1 (B)
2 2 (B and C)
The problem is that I'd like to visualize the totals without addign the id, in this case, looking for somethign like,
1 id with 1 product
1 id with 2 products
And I dont know how to do it... and guidance will be really appreciated!
Thansk in advance,
Miguel
7 Replies
correodelusak , Based on what I got so far.
If you have created a summarized table, this will not take slicer values. You need to join the new table with a common slicer or use a slicer from that
Not very clear on the later part of the ask. unless it because of above reason
Hi,
I just created a simplify project for my problem.
The objective is to visualize,
Total Ids with 1 item 1
Total Ids with 2 items 2,
https://drive.google.com/file/d/15mxEnWuBBrxf3El320nfNcPX6OU9ac48/view?usp=sharing
Appreciate the support
Hi amitchandak ,
It works for me... let me explain,
I have table,
id product
I created a summarized table,
table1 = summarize (table, table[id], table[product])
I join both table and table1 by id.
I created a slicer on table1 to filter products
This filter table1 passing the id to table, getting table filtered.
There is a second slicer on table, which filter table to get the function, slicer(table1) AND slicer(table).
If I apply a common slicer on both tables, I wont get the AND function, just OR.
That being said, and simplifying the use case, lets say I only have one table and apply one slicer,
How can I calculate the amount of id having 1, 2 or 3 products without usign the ids?
As previously said,
I know how to generate the following table,
id number of products
1 1 (B)
2 2 (B and C)
But I need a table as,
1 id with 1 product
1 id with 2 products
Best Regards,
Miguel
Hi, correodelusak
What is the final result table you want to show? What does the total number of visualizations refer to without adding IDS?
It would be better to provide examples of expected results.Please exclude the sensitive information before share these information. Thank you.
Best Regards,
Charlotte Zhang
Hi,@
If the method I provided above can't solve your problem, what's your expected result? Could you please provide more details for it?
Best Regards,
Charlotte Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
