Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi, I am trying to add up the number of calls that have so many IDs attached to them. So, for example 4 calls had 3 IDs attached to them, and so on. I am not sure how to display this in Power BI. I was hoping a Matrix would figure it out for me but this is what I got:
One call could have several IDs attached to it, or just one. So, out of the 7,617,384 calls, I'm trying to display that for example 100,000 of them had 3 IDs attached to them, 75,000 had 4 IDs, etc....can't figure out how to show this.
I created a new table (basically just number 1, 2, ... n), then used a measure to calculate the number of calls attached to an ID -
Count of IDs =
var temp = ADDCOLUMNS(VALUES('Table'[Ids]), "countIds", CALCULATE(COUNT('Table'[Ids])))
return COUNTROWS(FILTER(temp, [countIds] = SELECTEDVALUE(Frequency[Value])))
@vicky_ Thanks. Not sure if I've done this right since this is a new one for me. Here is the DAX based on what you said (I wasn't sure about what "Frequency[value]" was).
Count of IDs =
var temp = ADDCOLUMNS(VALUES('table'[ID]), "countIds", CALCULATE(COUNT('table'[ID])))
return COUNTROWS(FILTER(temp, [countIds] = SELECTEDVALUE('table'[CALL])))
I got the error message: Couldn't load the data for this visual because DAX does not support comparing values of integer with values of text. I am not sure where in this DAX I need to fix this (the CALL and ID data must be stored as text because they both have letters in their codes).
SELECTEDVALUE('table'[CALL]) is the part that's not working.
In my DAX, i've created a new table called Frequency with a column called Value - that is what i'm using in my equation, not the call string. If you still have trouble, please add some sample data.
@vicky_ I appreciate your help. Can you share with me the DAX for the table you created? I think I'm confused because in the illustration at the top it looks like you have a column Frequency and a column Value. I am not sure how those two are interacting with each other (if they are). Thanks!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
77 | |
60 | |
52 |
User | Count |
---|---|
165 | |
86 | |
68 | |
68 | |
58 |