I tried to calculate and make tabular format, which total number of records less than 5, less than 3, less than 2 and less than 1.
i could not figure it out how can i achive this as i am totaly new this power BI
Solved! Go to Solution.
You would create a couple measures in your data model. Data model tab on the left, Modeling, New Measure. The general formula would be:
CountLessThan5 = COUNTX(FILTER(Table, Table[Column]<5),[Column])
@Greg_Deckler: Thanks you. Its realy helps me your solution to my earlier posts also. Additionatly, i require to count, which is less than 5 and grater than 4 (like in between). how to define formula for that.
i am getting result count is zero, if i were use && opeator. i am getting proper result when i use || operator for first condition (COUNTX(FILTER(Feedback,Feedback[Avg]>5 || Feedback[Avg]<= 4),Feedback[Avg]) ).
when i use second condition for different measure field
COUNTX(FILTER(Feedback,(Feedback[Avg]>4 || Feedback[Avg]<=3)),Feedback[Avg])
this returning unexpected count (count is 8). For this condition the result should be two. But i am getting count 8, which are blank fields are also behind.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.