Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear Community,
I have to show weekly hour length in a slicer. I used the following DAX
that doesn't have any affect on the matrix. How I can create interactive measure/CC for the slicer? Thank you
Solved! Go to Solution.
Hi,
According to your shared file, there isn't any active relation between 'Hours Per Week 1' and 'Table' and also the other relations direction are to the particular tables, so we don't expect could filter the destination table based on the measure in other (no relational) table.
Please find the other design for your data model to create the relation (or active the inactive ones).
Appreciate to Kudos
Hi,
According to your shared file, there isn't any active relation between 'Hours Per Week 1' and 'Table' and also the other relations direction are to the particular tables, so we don't expect could filter the destination table based on the measure in other (no relational) table.
Please find the other design for your data model to create the relation (or active the inactive ones).
Appreciate to Kudos
I rebuilt the whole model, thanks for advice!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |