User Profile
f_e_user
Regular Visitor
Joined 3 years ago
User Widgets
Contributions
Two Subset of List - How to do it in DAX
Dear Guru of PowerBI, I've my data model What I'm trying to achieve is to find the Server that are not related to a Business Service. Server links to Business Service through Server.sys_id = Business_Service.child I managed to calculate the formula and verify it from client : Total Server = CALCULATE(DISTINCTCOUNT(SYS_ID['Server']), FILTER('Server', Active = "True")) Total server_BS= CALCULATE(DISTINCTCOUNT(child['Business Service']), FILTER(Server, Active = "True")) The Server that are not linked to a BS is given from measure Total Server (3560) - Total Server_BS(3500). So in this case, there are 60 Servers that have not been linked to a Business Service. I need to create a Drill Through Page where I show the these 60 Servers. I don't know how to do it in DAX, if it would be Python it would be like this : List_sysid_server = pd.Dataframe(df.id.filter(df['Active'] = True)) List_sysid_BS = pd.Dataframe(dfBS.id,filter(df['Active']= True)) #I Have Two Arrays of sys_ID (Sys_id is like "23ad9402adh24bt") #First Array contains sys_ID of Server #Second Array contains Child (that is Foreign Key, is a SYS_ID) #I need to obtain in dax, the SYS_ID in first Array that are not in second Array List_sysid_not_related = set(List_sysid_server - List_sysid_BS ) How can I show that 60 IDs that are Present in the server but not in the child column with DAX Logic?Cannot add Drill Through on Clustered Column Chart
Dear Guru of PowerBI, I have two pages : One page in which I show my cluster column chart composed of two columns (Business Unit and Service Line) another Page of detail in which for each Bussiness Unit I show the Service Line linked to it On detail page I've add Business Unit column as drill through but when I go on first page and click with left and then right on clustered column chart, it does not show me a drill through icon. Business Unit and Service Line are in the same table. Even through I set "Allow Drill Through as Category / Summarized" it doesn't work. It is possible ?Ordering a Date Hierarchy in a slicer
Dear Guru of PowerBI, I've a date "Opened_at". I've created Year,Month Number,MonthName columns to have on my date slicer only the real month and added it to a new Hierarchy This is how the months are showed. I would like have them order by Month Number and show them as 2023 Jan Feb Mar Apr May Instead of having them sorted alphabetically by name. If I add MonthNumber to Slicer, it sorts in a correct way, but I don't want to show the month Number. How Can I achieve This ?CTE Query Gives Error
Hello, I've a model data made with Import Connectivity. I've been tasked to convert it to DirectQuery and in several table they are all done with CTE. I have a CTE SQL Query That Runs fine on SQL Server when I launch this query I can see the data in PowerQuery When I click "Close and Apply" in PowerQuery I do receive this error Can you help me to solve this issue? Does Direct Query Supports CTE like WITH ?
