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,
Week 1 of power bi novice here!
I am struggling to get a measure to count what i need it to count.
I have 2 coloumns that i need to count based the values that are in there. Subcategory and quintile. Subcategory is the name of a product category and quintile is a letter given the a product within that category to highlight its importance. The letters are ABCDE
I want to count the number of A lines within a category and so on with b,c,d,e as sepereate mesures. However the challenge is. That the data set is at Product level so the subcategory field has duplicates within it. I can get it to count the total number of A lines but i need the measure to take into account the duplication of values that appear in the subcategory coloumn. The formula that im using to get it to this stage is below.
Solved! Go to Solution.
Hi AlexCorbin,
We can use the following DAX query:
Blines = CALCULATE(COUNTROWS(CKBKCRTABLE),FILTER(ALLEXCEPT(CKBKCRTABLE,CKBKCRTABLE[Subcategory]),CKBKCRTABLE[Quintile] = "B"))
The result will like below:
Best Regards,
Teige
Hi,
Please share some data and show the expected result.
Hi AlexCorbin,
We can use the following DAX query:
Blines = CALCULATE(COUNTROWS(CKBKCRTABLE),FILTER(ALLEXCEPT(CKBKCRTABLE,CKBKCRTABLE[Subcategory]),CKBKCRTABLE[Quintile] = "B"))
The result will like below:
Best Regards,
Teige
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |