Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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 |
---|---|
30 | |
18 | |
15 | |
14 | |
10 |