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.
Having difficulty with this function trying to suppress data.
I ahve to suppress student counts where n<10, except for school number "0A000A". But, Keep receiving this message:
"A single value for column 'LEAschool' ion the table 'School_Directory_DIM' cannot be determined.This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max...."
Hi @MD_POWER_BI
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MD_POWER_BI ,
In measure you need to use aggregated values or table functions in this case you need to wrap the School_Directory_DIM in a SELECTEDVALUE or a DISTINCT. that way you are abble to get the expected result.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |