Forum Discussion
Last values from measures in a table
Hi zenton ,
You can create a measure as below and put this new measure onto the card visual:
New Measure =
MAXX (
GROUPBY (
Labware,
Labware[Date],
Labware[LIMS Text ID],
Labware[Analyte],
Labware[Freq],
Labware[Grade]
),
[Limiting Contam Test]
)
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Hi Anonymous
Calculation won't accept Labware[Grade] or Labware[Freq] because they are Measures.
I can try to make simplified pbix file but not easy to do. 80 Tables, 50 relationships and 320 Measures
Thanks Rodney
- zenton4 years ago
Helper II
Hi Anonymous
I have made a simplififed version of PBIX with 2 sample reports
https://drive.google.com/file/d/1UHjufS9u05rF7qXdmsnb_bGGNajBFDa5/view?usp=sharing