Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi.
I have a virtual table like this
This one is a virtual table that the third file changes depending on the data filter as I show you with scenarios.
My virtual Table was created great with this Dax code:
Solved! Go to Solution.
I have the solution for my trouble.
I couldnt have one calculated table because my user type changes depending on the date filtered.
Like I have 3 user types, I decided to create a measure for each type, calculating one virtual table and filtering for each measure and each user_type with the user_type and calculating the number of users.
It works ¡¡
I have the solution for my trouble.
I couldnt have one calculated table because my user type changes depending on the date filtered.
Like I have 3 user types, I decided to create a measure for each type, calculating one virtual table and filtering for each measure and each user_type with the user_type and calculating the number of users.
It works ¡¡
Hi @PPDiaz1978 ,
If you don't want the type user to change as the data is filtered, you can create a table of unrelated data to be used as a slicer and then use measure to customize the rules to influence.
If it's convenient, you can show your expected results in the form of images and or share the pbix samples after removing sensitive data. We can better understand what the problem is and help you with it.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
User | Count |
---|---|
50 | |
24 | |
18 | |
17 | |
14 |
User | Count |
---|---|
91 | |
86 | |
39 | |
25 | |
20 |