Percentage change of a count

[abeirne]

Hi good morning, I am working on some data that calculates the count of a text Y/Y. This is for different types of reservations (cancelled, lost, quote, reservation, and booked alternative). I was wondering how to create a percentage difference with the count values, as the values I am working with are not numbers. Would I be able to create a measure that divides by a count, or is there another way I should be looking at this? The data I was given does not have a table that shows the count of status (the types of reservations) so maybe I should be looking into creating a table that shows this?

Thanks so much, any help is greatly appreciated. I can also explain more if needed

[ValtteriN · Accepted solution]

Hi,

Count measure seems like a good way to approach this. Another alternative would be COUNTROWS combined with FILTER. So e.g. COUNTROWS(FILTER(ALL(Table),Table[Type]="Cancelled"))

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

[abeirne]

Thank you so much. It is returning the total amount however, is there a way to filter it by date? I have this:

Quotes Cancelled =

COUNTROWS(

     FILTER(

          ALL('gcQuoteSent'),

          'gcQuoteSent'[Status 2] = "Cancelled" &

          'gcQuoteSent'[QuoteSentDate].[Date] <= "1/1/2020"

)

)
But this is returning an error, and won't display the visual in a table

[ValtteriN]

Hi,

Try removing the .[Date] from the DAX. If your date column is in the correct format you don't need it. Additionally, it might cause an errot depending on your table.