Forum Discussion
DAX
Hello I Need to find here the following No. of sites codes >= 1.5 average value So Above are the Site Codes in 2nd Column for different Toxin Names at different year . So One Site code ...
Hi sanju24566 , I think this is the solution.
1. Create a summarized table in Power BI, go to the modelling tab and click on the new table option as shown in the below screenshot.
Summarize_table =
SUMMARIZE(
'table1',
'table1'[Site Code],
"AvgValue",AVERAGE('table1'[value])
)
)
2. After this you can create calculated column to for your condition of value 1.5 average value.
calculated column = IF('table1'[AvgValue]>=1.5,1,0)
So now you filter 1 you will be able to see the site codes where the avg. if the value is greater and equal to 1.5.
Regards,
Nikhil Chenna
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Did I answer your question? Mark my post as a solution!
thanks but isnt this possible with measure
Hi sanju24566 ,
Try using Summarize with measure and let me know. Creating a summarized table is suitable in this situation.
Regards,
Nikhil Chenna
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!Hello Nikhil
Thanks for the solution. But the results are not what I expected
I wanted to know the No. of Site Counts >=1.5 yearwise. It is showing me the Total Count of Site Code
This is what I want to achieve. Can I use a related function anywhere?