Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi dear helpers,
i have this kind of data table and i wish to build the correct measures/calculations in order to show this kind of bar chart (attached below).
i actually need to calculate how many customers were sent X messages successfully.
can you please assist me with the right DAX for it?
for the below data:
in Jan'22, 1 customer (id=2) has been delivered 1 message successfully, and 2 customers (id=1,3) has been delivered successfully 2 different massages
thanks in advance.
Solved! Go to Solution.
@akfir ,
first you need to create month name column in your table like below using below code
Month = FORMAT('Messages Delivered'[Date],"MMM-YY")
then create a measure using below logic then use it in your visual you will get your desired result,
Count of meassage =
CALCULATE(COUNT('Messages Delivered'[Customer ID]),'Messages Delivered'[Delivered?]="TRUE")
Thanks,
Arul
Hi akfir
I succeed but I think there is an easy way to do it.
the table name with datas on this page have this name here : 'BAR CHART CALL (2)'
First I create a new table :
Hope this helps but I am pretty sure that there is an easy way to do it !! 🙂
@akfir ,
first you need to create month name column in your table like below using below code
Month = FORMAT('Messages Delivered'[Date],"MMM-YY")
then create a measure using below logic then use it in your visual you will get your desired result,
Count of meassage =
CALCULATE(COUNT('Messages Delivered'[Customer ID]),'Messages Delivered'[Delivered?]="TRUE")
Thanks,
Arul
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
8 | |
7 |