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.
Hi everyone,
I want to group my index list based on the difference between their Max and Min Value.
I can't really figure out why my idea won't work, everything seems fine.
I share below my sample file.
https://drive.google.com/file/d/1-0FFmgcW3ILsubHVMJfe-8z7K_V5bys3/view?usp=sharing
Important thing, the grouping must be created in a column, because I want to filter my data by it.
Thanks In advance for any help!
After a quick look at your model, it seems that your relationship isn't correct.
You are linking 'IndexList'[ItemID] -> 'IndexList'[ItemID] instead of 'IndexList'[Item Number] -> 'Values'[ITEMID]
Thanks @Anonymous for noticing!
It's a dummy mistake, but in my main model that's not the issue, it's something else.
After fixing relationship, it still shows some blank grouping.
I don't see anything that's wrong, I think the measures are working correctly.
But in the dataset you have some infinity values, and the max for bad = 1000000. So ofcourse infinity - Min= infinity so it's normal that there are some blank values.
@Anonymous
Thanks again 😉
I finally figured it out.
I should have to add one more column from my model.
Because in the table Value there is also a column with Dates.
And this dates was filtered by page filter.
So I suppose that this filter doesn't work on measures with function MAX or MIN?
If am I correct, how to add this filtering to my measures?
Maybe my logic was wrong?
That I can't group index by difference between Max and Min value.
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 |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |