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.
Solved! Go to Solution.
I'm not sure but I am guessing you want it as a column so you can put it in a slicer? If so, you can add a calculated column to your table that will give you the same result:
Column = VAR StoreNum = 'Table'[STORE #] VAR VisitDate = 'Table'[VISIT DATE] VAR CallCount = CALCULATE( COUNTROWS('Table'), FILTER ( 'Table', 'Table'[STORE #] = StoreNum && 'Table'[VISIT DATE] = VisitDate ) ) RETURN IF ( CallCount = 1, 2, 1)
Hello @Ahead4097
The following measure will return the result you are looking for, you will just have to change the name of your table.
Measure = VAR StoreNum = VALUES('Table'[STORE #] ) VAR VisitDate = VALUES('Table'[VISIT DATE] ) VAR CallCount = CALCULATE( COUNTROWS ( 'Table' ), ALL ( 'Table'[CALL ID] ) ,StoreNum ,VisitDate ) RETURN IF ( CallCount = 1, 2, 1)
I also uploaded my testing .pbix so you can take a look it it: https://www.dropbox.com/s/jyoxwrae8rmz5y8/CallIDCount.pbix?dl=0
The RowCount measure just counts the rows in 'Table'. If we look at a STORE # and VISIT DATE pair we can see the ones that have more than 1 CALL ID. Further, if you click on a line in the first visual it will filter the second visual to show just the CALL ID that hit in that STORE # on that VISIT DATE.
Is there a way to do this measure in Power Query Editor?
I'm not sure but I am guessing you want it as a column so you can put it in a slicer? If so, you can add a calculated column to your table that will give you the same result:
Column = VAR StoreNum = 'Table'[STORE #] VAR VisitDate = 'Table'[VISIT DATE] VAR CallCount = CALCULATE( COUNTROWS('Table'), FILTER ( 'Table', 'Table'[STORE #] = StoreNum && 'Table'[VISIT DATE] = VisitDate ) ) RETURN IF ( CallCount = 1, 2, 1)
This is perfect, thank you!
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |