Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Proud to be a Super User!
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
Proud to be a Super User!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!