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
I've got a colum that contains text and integers. I'd like to know home many unique codes (integers) there are in my dataset.
Can someone help me out? So I only want to count the cells with the integers in the example.
Solved! Go to Solution.
Measure 3 =
VAR __Table = ADDCOLUMNS('Table4',"__IsNotInt",ISERROR(INT([Column1])))
RETURN
COUNTROWS(DISTINCT(SELECTCOLUMNS(FILTER(__Table,[__IsNotInt]=FALSE()),"Int",[Column1])))
@jochendecraene Maybe:
Measure 3 =
VAR __Table = ADDCOLUMNS('Table4',"__IsNotInt",ISERROR(INT([Column1])))
RETURN
COUNTROWS(FILTER(__Table,[__IsNotInt]=FALSE()))
Thanks for the quick response.
This gives me the number of cells containing integers. But can I have a distinct count of the codes?
Measure 3 =
VAR __Table = ADDCOLUMNS('Table4',"__IsNotInt",ISERROR(INT([Column1])))
RETURN
COUNTROWS(DISTINCT(FILTER(__Table,[__IsNotInt]=FALSE())))
that is giving me the same count as without the 'dsitcint' ... I made a test column with 291 times the same code. The two measures return 291 as result. I've expected the new measure to return 1 ...
Measure 3 =
VAR __Table = ADDCOLUMNS('Table4',"__IsNotInt",ISERROR(INT([Column1])))
RETURN
COUNTROWS(DISTINCT(SELECTCOLUMNS(FILTER(__Table,[__IsNotInt]=FALSE()),"Int",[Column1])))
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 | |
97 | |
80 | |
67 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |