Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello all,
I'm trying to solve an issue but cannot get my head around the problem so hopefully you are able to help me out.
My problem is to find from the data the types that use only common module and nothing else.
So for example from sample below This type: 004179e4772fecfd918bdfcf9465b330187fb7a57b2267f6607a39a37d442141. That has been using only Common. Other types have been using common also but also others.
Seems an easy filtering but I just could not figure out how to.
Thank you.
Solved! Go to Solution.
Place the type in a table visual
Create a measure that:
contains the type in a variable _type
counts the rows that have the module - Common and type - _type <- put in a variable C
counts the rows that have the module is not equal to Common and type _type <- put in a notC variable
if C >0 and notC to 0, returns 1 (to indicate true, you can display or filter it)
Hi @TeroK ,
Add a filter on the visual.
Or create a measure.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thank you for your proposal but that does not work.
By filtering only common there are still the types that have been using others as well. It just filters the other rows away.
The thing was that I want the types that use only Common module. If you check my attached picture you might get my idea. In that picture there are two types that I would like to be left after filtering.
Those are these:
004179e4772fecfd918bdfcf9465b330187fb7a57b2267f6607a39a37d442141
00511d1cad6fb6c4d58911696b811f6b2765ca310bd7d69ccf3acc3c4e2282d7
Thanks.
Place the type in a table visual
Create a measure that:
contains the type in a variable _type
counts the rows that have the module - Common and type - _type <- put in a variable C
counts the rows that have the module is not equal to Common and type _type <- put in a notC variable
if C >0 and notC to 0, returns 1 (to indicate true, you can display or filter it)
Big thanks, I got it working with your suggestion.
User | Count |
---|---|
124 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |