The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I want to calculate a measure (_sellouts %) for different time periods (Day, week, month, year) selected by user.
It works almost fine:
But, as you can see Maximum value calculates wrong.
If I get rid of selection and hardcode time period, the same code works well:
It seems as if Max per category doesn't work with NAMEOF() functions.
How can I get the maximum?
hello @gavexe as per my experience, you need to create a relationship between (_sellouts %) measure table and the NAMEOF() table. Thank You.
User | Count |
---|---|
12 | |
9 | |
6 | |
6 | |
6 |
User | Count |
---|---|
24 | |
14 | |
14 | |
9 | |
7 |