Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, I have a virtual table agregada con User y User_Type ... and I have a dimension table about User_Type
Usuario Tipo de usuario
Usuario1 Tipo1
Usuario2 Tipo1
Usuario3 Tipo3
I cant do a normal relationship between User Table and User_Type Dimension Table because the user_Type can change depending from date filter.
I have buid the follow code:
I have 4 users in my case ... Like I cant do a relationship between user table and user_type dimension table because user_table is T1 that is a virtual table ... The chart told me that exist 4 users for each user_type.
This will resolve with a relationship but I have proved a lot of thinks (Treatas, ... ) but it doesnt work anything
Some idea ???
Thanks
Solved! Go to Solution.
I got it
I dont need a relationship. I need 3 measures, one measure for each type_status.
Each measure like this:
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
I add the data
I cant do a direct relationship between two tables because type user in User_type table is dinamic and depend on the filter data
I got it
I dont need a relationship. I need 3 measures, one measure for each type_status.
Each measure like this:
User | Count |
---|---|
65 | |
46 | |
20 | |
18 | |
15 |
User | Count |
---|---|
120 | |
41 | |
40 | |
28 | |
23 |