Hi all,
I am new to PowerBI and need help with the following question. I cant share the data so I'll try my best to explain it clearly:
I have a large dataset (table1) with thousands of addresses (rows) and their square meters, the amount of residents, etc. in columns.
I want the total number of addresses (rows) in a card based on two conditions, namely m2 being equal or higher than 80 and the amount of residents equal or less than 2. This card should interact with 2 sliders in my report.
Based on previous posts on this forum I figured out I have to create a measure and use this as input for the card, I came up with the following formula:
Total amount of addresses = COUNTROWS(FILTER(table1, table1[m2]>="80" && Table1[residents]<="2"))
This formula didn't give me an error immediately, unlike others i've tried, but when I use it as input for a card I get an error saying it can't show the visual element because DAX can't compare number with text values. The value type of both columns (m2 and amount of residents) are both set to numerical and so i'm stuck.
Is there anybody that can point me in the right direction?
Thanks in advance.
Michael
