Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey all,
I want to calculate the number of tenant per application.
1. I tried using power query i.e conditional column
if application contains X give X,
if application contains Y give Y,
else Others
But when i try to do that it is not giving me the accurate result
if you can see tenant id "A" Has X ,Y,Z so it should be counted in three of the results but it is just showing it in the X and Others
2. I even tried using dax
data---
Tenant ID | Application |
A | X,Y,Z |
B | Y,R,T |
C | X,Y,T |
D | R,T,X |
Please give me an suggestion how can i solve this problem.
Solved! Go to Solution.
Hey @YASHASHRI , you can try this measure:
tenantID# =
VAR current_app = SELECTEDVALUE ( Table_2[Application] )
VAR tenantsWithApp = FILTER ( Table_, CONTAINSSTRING ( Table_[Application ], current_app ) )
RETURN
IF ( ISFILTERED ( Table_2[Application] ), COUNTROWS ( tenantsWithApp ) )
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
@YASHASHRI , yes, this is the first table. And you need a table with your applications as a dimension table.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
Hey @YASHASHRI , you can try this measure:
tenantID# =
VAR current_app = SELECTEDVALUE ( Table_2[Application] )
VAR tenantsWithApp = FILTER ( Table_, CONTAINSSTRING ( Table_[Application ], current_app ) )
RETURN
IF ( ISFILTERED ( Table_2[Application] ), COUNTROWS ( tenantsWithApp ) )
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
what are you taking as Table_2 and Table_????
tenantID# = VAR current_app = SELECTEDVALUE ( Table_2[Application] ) VAR tenantsWithApp = FILTER ( Table_, CONTAINSSTRING ( Table_[Application ], current_app ) ) RETURN IF ( ISFILTERED ( Table_2[Application] ), COUNTROWS ( tenantsWithApp ) )
Because in my case there is only one table and that is the below one
Tenant ID | Application |
A | X,Y,Z |
B | Y,R,T |
C | X,Y,T |
D | R,T,X |
@YASHASHRI , yes, this is the first table. And you need a table with your applications as a dimension table.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |