PowerBI dataset simple relationship issue
Hello guys, I am unable to understand why I cannot create visuals with data from my two fact tables joined through a dimension table. The schema is described below, I joined the two tables through a dimension based on the same id. If I want to create a visual in which I pull attributes from Fact One and Fact Two, i get an error saying there is no valid relationship between the tables. I tried switching the cross filter direction to 'both' for both relationships: did not work. Tried to pull attributes from all three tables, thinking that maybe all three tables have to contribute to the visual for it to work. Same issue. The only way I can link the two tables in the same visual is by doing a many to many relationship between the two fact tables. What am I doing wrong? Also, I have a similar issue with products table where I am linking Fact Two to Product table (fact:many to product:one), then linking Product dimension to Product Options dimension (Product:one to Product Options:many). I cannot split the fact table sales data by Product Options. The only way to make it work is again, doing a many to many relationship between Fact Two and Product Options. Please help!
ALL function not working in PBI report, but works in PBI Dataset
Hello everyone, My issue: I have a PBI report connected to a PBI dataset. The Total Headcount formula using the ALL function on a field works in the dataset - when I use that exact field as a slicer it is completely ignored -, but does not work in the PBI report which is connected to it. More details: In the dataset, I have HR data (Terminations and Headcount). The thing is that for Terminated people, I have termination type (Involuntary, Voluntary and Unknown) and for Headcount records the Termination Type will always be BLANK. All data is appended in a single table. I wrote a Total Headcount formula using the ALL function based on Termination Type -> I want to use a "Termination Type" slicer to filter the sum of terminations by voluntary/involuntary/unknown, but these terminations must be divided to the Total Headcount irrespective of the Termination Type (as the Termination Type will always be BLANK) must not interact with the "Termination Type" slicer Total Headcount = VAR TotalHC = CALCULATE ( SUM ( 'HR Metrics'[Measure - Preview Count] ), KEEPFILTERS ( 'HR Metrics'[Measure Type] = "Headcount" ), 'HR Metrics'[Employment Status] = "Active", ALL ( 'HR Metrics'[Termination Type] ) ) RETURN IF ( ISBLANK ( TotalHC ), 0, TotalHC ) All works wonders in the dataset, see the below screenshots: However, the exact same things do not work in the PBI report which is connected to this dataset, see below the weird behaviour that I get. Normally, when I select anything in the "Termination Type" slicer, the headcount value should be as above. However, as you can see, it is not. I am confused why I even get a headcount value <> 0 when I select a value in Termination Type (as mentioned, the Termination Type for headcount will always have BLANK as vlaue) Any help in this matter will be greatly appreciated. Let me know if you need more info.
