PBI | Practical Bayesian Inference | Machine Learning library

I'm new to PBI/DAX. I have a table called Opp Recs with a few columns: Group1, NumEmp, OppRec, AcctNum. I want to sum the NumEmp column if Group1 equals "Corp Employees" but only for unique AcctNum.

I used this formula but realized NumEmp was double counted for dup AcctNums: **Corp # Emps = CALCULATE(SUM('Opp Recs'[NumEmp]), 'Opp Recs'[Group1] = "Corp Employees")**

How can I sum NumEmp correctly?

Sample Data:

Group1    NumEmp    OppNum    AcctNum Corp Employees    450  000030689  A0000123 Corp Employees    450  000030624  A0000123 Corp Employees    150  000030118  A0000662 Small Bus Emp      5  000030637 A0000737 Small Bus Emp      37    000030738  A0000755 Corp Employees    100    000030639   A0000784 Corp Employees    100    000030616   A0000784 ...

Good day to all of you. I have a problem with probably not fully understanding how to embed PBI report in my Xamarin app.  I got my access token and I used Master User for this, but after i GET EmbedUrl and put it in Source proprety of WebView, i get a message: "Please sing in to view this report". This is a problem because my customers don't have PowerBi account and I want them to be able to see this report. Problem might be in my headers I use to get access token, so below is code I use

...

Is there some way to identify all cmdlets used in a script file? What I am trying to find out is find requirements for deployment to another environment. What modules have been used? Which version is installed? Then can review the list of command and know what to install in the new environment.

Let's use the below file as an example. Once I know the cmdlets then I can use get-command to find out the module/version installed. Reference: Find PowerShell cmdlets with Get-Command | 4sysops

Thanks for your advise.

Cmdlet dependencies (example output) ...

Given a URL like this: https://xyzt-pbi.co.com/reports/powerbi/Platform%20Status%20Reports/MSAS%20PBI%202019%20v10

How do i parse the server in powershell, in other words, i want this portion only: xyzt-pbi.co.com

...

I'm pretty new to Power BI, and what I'm trying to do is replicate an excel table in PBI. The following is a table of both what I have in PBI and What I want.

I'm trying to get the gap or cushion for a medical agenda, and also to get the actual date. In excel, I get the nearest appointment and the farthest appointment, which changes if I filter by medical professional. I did it thanks to the subtotal function.

In italic, there's data I haven't gotten yet (in excel, I've randomly assigned it), but because of the message:

Expressions that yield variant data-type cannot be used to define calculated columns

I've noticed that it's problematic to mix text with numerical values with the IF function. If it could be crcumvented, it would be great, but in the end, it will be better to use 1 and 0 to determine if a slot has been taken.

So, instead of a "not available" message, I'm currently forcing the date to be the actual 0 of the system if the appointment has already gone by, and I hope to add the condition that if the slot is taken, it also returns 0

However, my main concern is that, I don't know how to make a MEASURE that returns the minimum and maximum Open Slot.

Area Profesional Slot ¿Taken? Gap Open Slot Area John Doe 15-dic-2020 13:00 no e.g: -131,18 15-dic-1899 00:00 Area Jane Doe 30-apr-2021 10:00 yes Slot - NOW() 15-dic-1899 00:00 Area Jane Doe 30-apr-2021 11:00 no Slot - NOW() 30-apr-2021 11:00 Area Jane Doe 30-jun-2021 10:00 no Slot - NOW() 30-jun-2021 10:00

For the table APPOINTMENT, I tried to create the measure:

Next_Slot = MINX(APPOINTMENT, IF(APPOINTMENT[Open_Slot] > NOW(), APPOINTMENT[Open_Slot], "No Appointment Available)) but all I'm getting is the actual minimum value, which is 15-dic-1899 00:00

I'm guessing that I either have to:

(1) circumvent the text and numbers issue in the IF function, so that I get the "Not Available" instead of 15-dic-1899 00:00 in the last column, and the MINX function will hopefully return the actual slot that is both free and further down in time than NOW(), ignoring the non-numerical values.

(2) actually make the MINX function take into consideration the IF function so that it ignores the dates earlier than NOW().

And what I ultimately want to show in the dashboard is:

(1) The next available slot, and the farthest available slot (2) The time between NOW() and the two above (3) being able to filter by Area and By proffesional, and other additional non-numerical

Any ideas?

...

I'm working on a project where we are converting a client from Tableau to PBI. One of the Tableau reports I'm converting looks like this:

Each row is a different calculation (measure). I can achieve a similar look, with regards to the column headers, in PBI by using a matrix. However, there isn't a way, that I know of, to apply a different measure for each row. The only way I can think of to do this is to create three matrix tables and stack them on top of each other. It won't look nearly as good but I can generate the same results. Does anyone have a better solution?

...

Currently the configuration to embed a specific visual through the JS powerbi-client does not allow passing in filters. See "Embed a report visual" for the configuration supported. Note that you are able to pass in filters at embed time for a report. See "Embed a report". Not being able to filter a visual at embed time results in 2 hops (once to load the visual with default filters, then another to load with expected filters).

Feature Request: I'd love for the feature to be added to filter at embed time for visuals like it exists for reports.

The way I do this now is hide the visual, embed it, set filters when loaded, then show it when rendered.

...

I have added a new custom state called "In Code Review" into Azure DevOps Server 2019. I did it by going through Visual Studio and importing/exporting the WIT for PBI. The WIT for PBI I updated was to add the following (in the relevant sections)

...

What would the equivalent DAX be for this SQL?

SELECT AVG(CountRows) FROM pbi.FactVend AS FV JOIN pbi.DimAsset AS DA ON DA.KEY_Asset = FV.KEY_Asset WHERE CAST(FV.KEY_VendDate AS Date) NOT BETWEEN DA.ExcludedFromDate AND DA.ExcludedToDate

I have two tables, Vend and Asset. I want to exclude the rows from Vend where the VendDate is in an excluded period. Something like below however I can't get the DAX right. If i filter Vend it cannot see the Asset columns also doesn't seem to like being supplied convert date, KEY_VendDate is Int YYYYMMDD...

...