Problem showing a column from a Calculated table

[Anonymous]

Hello guys!

I would like to ask for you help in the following problem I've being stocked in.

I did created a Date Calculated table made from DAX

I would like to make a flag column witch mark sundays  as 1 and the rest of the week days 0.

Then count how many days in 1 and in 0 do wee have per month.

for that I already did the flag column 

But when I only try to display de 0 and 1 value of the Column DiaLaboral, the column doesn't display any value at all.

Am I missing something?

Thank you for the help!

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

If you want to display the value of  'DiaLaboral' column in table visual. You should drag other column in values of table visual. Or you can view it in Data page

According to your descriptions, if you want use the table visual to show the count of sundays and week days for per month.

I suggest you drag 'Year' column, 'Monthnumber' column,two 'DiaLaboral' columns (set one of it to 'Don't summarize' and the other one to 'Count') into values of table visual.

Please refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EUHf6ecwjN1Fnp7mpIfNEKsBqVbft8cZv1_OclDl5_UvVQ?e=ytz5Kl

Best Regards,

Dedmon Dai

[amitchandak]

@Anonymous ,Create a new column

Sunday = if(Weekday([Date])=1,1,0)

In visual you can use Sum(Table[Sunday]),

In case of No data just check for any filters on the page

[Ashish_Mathur]

Hi,

To your Table visual, drag MonthNameShort to the row labels and write this measure

COUNTROWS(Date)

Hope this helps.