userelationship

Hi, I'm struggling to get this to work, any solutions would be much appreciated. - data shows forecasted and actual sales for the year. - data has two date cells, 'projected close date' and 'actual close date'. i.e. when we think it's going to land and when it actually landed. - want to create...

I've got a measure where I'd like to have a USERELATIONSHIP clause in the CALCULATE. The code below works... however, I'm not clear why I can't add the USERELATIONSHIP as a filter parameter to the "inner" CALCULATE. If I do that without the outer CALCULATE the measure returns blank<blank>...

Here is an interesting one. I have been reworking my DAX to clean them up utilizing Variables. However, I have discovered (or not doing it correctly) that when I use a VAR in a Calculate that utilizes the USERELATIONSHIP DAX it ignores the DAX and defaults back to the active relationship...

Dear Team, I am trying to use SAMEPERIODLASTYEAR in CALCULATE. My formula did not work because I cannot have a relationship between the Data Table and the Fact Table. So I was intending to use an inactive relationship and then activate it with the USERELATIONSHIP function, but when I checked...

Hello, My worksheet has these 2 tables: (Title is blank whenever Special Title is not) The relationship to Assigned City Key is inactive: These are my measures: Current non-accountants:=CALCULATE(COUNTROWS(Employees)...

I am doing a basket analysis in Power Pivot, and I am almost there, but am hitting one last snag which I cannot figure out. The question I am trying to answer is how many customers purchased a specific product (with net revenue greater than zero), along with another product (with net revenue...