% in power bi table

[AnkurSharma]

Hi ,

I need some help here ,

I am trying to create one Table in power bi .

1st column I need Count of without date in column and Total count in second column ( with date and without date ) & 3rd column % (count of without date / Total count)

I applied filer on visulisation of No date so when i drag another count that filter applies to this.

In need one colum have those which dont have date 

2 nd column shows Total count

3rd column shows no date count/Total count

Or simply we can say i am trying to show % of No date.

[Anonymous · Accepted solution]

Hi @AnkurSharma ,

I created a sample pbix file(see the attachment), please check if that is what you want. You can create the measures as below to get it:

Count of No date = COUNTROWS ( FILTER ( 'Table', ISBLANK ( 'Table'[WO Date] ) ) )

Total Count = COUNTROWS ( 'Table' )

% of No data = DIVIDE ( [Count of No date], [Total Count] )

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[amitchandak]

@AnkurSharma , What do you mean by no Date, ignore date context

calculate(count(Table[Column]), removefilters(date))

or

calculate(count(Table[Column]), all(date))

Or remove all filters

calculate(count(Table[Column]), all())

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.