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.
Hello everyone,
I have a matrix with different level of granularities:
I want to put a measure in column, but the measure should do different calculations at Contract level (sum the related projects) and project level (find a value in a related table), and return nothing at Risk level.
Any hint? I have tried with HASONEVALUE for risks, IF(HASONEVALUE(RiskNumber), "", IF(HASONEVALUE(Contract), SUM(...)...
But I have Project with only 1 risk, which then makes the related project and contract to have also ""
If you have any ideas to get me started on the right path.
Thank you for your time,
Tom
Solved! Go to Solution.
hi @Anonymous
You could get it by use ISINSCOPE Function to create a IF measure, see more detail as below:
https://xxlbi.com/blog/new-dax-function-isinscope/
Regards,
Lin
hi @Anonymous
You could get it by use ISINSCOPE Function to create a IF measure, see more detail as below:
https://xxlbi.com/blog/new-dax-function-isinscope/
Regards,
Lin
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |