Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have 3 slicers coming from a date table:
Fiscal Year (Includes 2020, 2021, 2022 etc)
Month Name (Includes May, June, July etc)
Period (Includes Period 1 and Period 2)
I have the following measures:
Total Hours for Period
Total Hours for Month
I'm looking to have a new single measure based on slicer selections.
1. For example, if FY21 and Month Name: February is selected I would like to return the Total Hours for Month
2. Example 2, if FY21, Month Name: February, Period 1 or 2 is selected then I would like to return Total Hours for Period
3. Example 3, if FY21 is selected then I would like to return the Total Hours for Month (over 12 months)
I was looking online and it looks like I can use Hasonevalue and Selectedvalue, but wasn't sure how that would work exactly. I started with this:
Hi @Anonymous
Does your Hour table contain a date column?
From your statement, you just want to filter the sum of hours by Year, Month and Period in Dim Date Table.
So, I think you don't need to build a measure. Just build a relationship between Date columns in two tables.
For reference : Create and manage relationships in Power BI Desktop
Then the result will be filtered by slicers.
Or you can share a sample without sensitive data with me by your Onedrive for Business.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |