Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Calculate with boolean filter and corresponding slicer not working

Hi all,   UPDATE: I have moved this to Issues   I have three measures counting rows in table: Nr Of Tasks = COUNTROWS(Tasks) Nr Of A Tasks = CALCULATE([Nr Of Tasks]; Tasks[TaskType] = "A") Nr...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Excelside,

 

I was too fast to consider this as solved, I have re-created this error in a small power bi file and this is a onedrive link to the file

 

https://1drv.ms/u/s!At5OeG4R7nfOhLByG0IU1__p5gVOYg

 

The problem is when post codes are only associated with one type of task, i.e. either A or B then this happen.

 

Best regards,

Kristjan

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Anonymous

 

In your .pbix, you put PostNr on rows in your matrix, it will slice all three measures. When you select Type 1 and apply "not 7000" report filter, it will filter out PostNr 8000 and 9000 only from the table. Then PostNr will slice all three measures including COUNTROWS for Type 2, so that you will get 4 on PostNr 8000 and BLANK() on PostNr 9000. This is expected behavior.

 

 

Regards,