Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 |
---|---|
17 | |
17 | |
14 | |
13 | |
13 |
User | Count |
---|---|
17 | |
14 | |
11 | |
10 | |
8 |