Forum Discussion
Advocate IPower BI Data Modeling Question
Thanks for reaching out. I changed my design and created separate views for all 3 metrics instead of using parameters. I was able to achieve the right numbers and did not miss any departments with this approach! I used bookmarks to handle the same effect
Advocate IThank you for your response. I think I found the issue, but still not sure about the fix. I created a parameter that includes metrics from both data sources. If I use that parameter to change the metric, the Student -> Healthcare management disappears. Instead, I tried validating by just placing the count of students (same measure in parameter), and it works. I need to figure out why the parameter is behaving strangely!
Community SupportHi RajiKarthik,
Thanks for reaching out to the Microsoft Fabric Community forum. and thanks to krishnakanth240 for sharing valuable insights.
That additional test is useful. Since the Student measure works correctly when added directly to the matrix, I would compare that result with the same measure when selected through the field parameter.
Microsoft documents that field parameters can dynamically switch measures or dimensions in a visual, and measure-based field parameters can be used in the Values field.
You could check the following:
> Test each measure from the field parameter directly in the matrix and compare the results.
> Verify that the parameter uses explicit DAX measures, as implicit measures aren't supported for field parameters.
> Review the field parameter definition. Microsoft documents three columns for each field: name, field reference, and order.
> Compare the DAX of the affected measure with the direct measure, particularly where filter context or relationship propagation is involved. Microsoft notes that explicit measures can affect filter context and relationship propagation.
This comparison should help identify whether the difference is related to a particular measure or to how it is represented in the field parameter.
For more details, please refer to the below Official Microsoft Documentation:
Use Field Parameters in Power BI Reports - Power BI | Microsoft Learn
Understand star schema and the importance for Power BI - Power BI | Microsoft Learn
I hope this helps. Please feel free to reach out if you have any further questions.
Thank you.