Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone. I have a rather strange question.
I have two table visuals derived from two completely unrelated tables (no relationship existing between them) after applying a few slicers and filters. However, i wish to add another column to the second visual based on the 'count' column in the first visual. More details below.
First Visual :
Date Category Count
01/01/2020 A 2
02/01/2020 A 4
05/04/2020 A 3
12/06/2020 A 1
Second visual :
CUS Hours New column to be added = Hours * Count
abc 5 10
abc 7 28
abc 6 18
abc 3 3
Is this even possible? Is there a way to index the rows (one thing remains constant : number of rows in both the visuals)?
Thanks
Solved! Go to Solution.
Hi @Zabeer ,
I think you could create an index like below, then use measure to get this result
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Zabeer ,
I think you could create an index like below, then use measure to get this result
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Zabeer , there should be some common dimension to create a correct calculation
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |