Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
a10703
Helper I
Helper I

Countrows with Column A string and B number

Hi guys,

I need help in one measure.

 

I have the format Column A = String and the Collumn B = Number

I need to count the number of rows that meet these requirments:

Count if the value on column A is = "NACIONAL" and if the value on column b ="0" or "1" .

 

But my measure appears one error "MdxScript(Model) (121, 167) Calculation error in measure "Table1"[feedbackmeasure]: Function 'CONTAINSROW' does not support comparison values ​​of type Text with values ​​of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.

 

My measure:

feedbackmeasure= calculate(counta('Table1'[COLUMN A]),Filter(Table1,Table1[COLUMN A]="NACIONAL" && Table1[COLUMN B] IN {"0","1"} ))

 

Datatable:

COLUMN ACOLUMN B
NACIONAL1
INTERNACIONAL3
NACIONAL4
NACIONAL4
NACIONAL1
INTERNACIONAL3
INTERNACIONAL3
NACIONAL0
NACIONAL1
NACIONAL0
INTERNACIONAL3
INTERNACIONAL3

 

Some solution for this?

Thanks

1 ACCEPTED SOLUTION
AntonioM
Solution Sage
Solution Sage

"0" and "1" are both Text, because you've enclosed them in quotes. 

 

Try 

Table1[COLUMN B] IN {0,1}

and see if that works

View solution in original post

1 REPLY 1
AntonioM
Solution Sage
Solution Sage

"0" and "1" are both Text, because you've enclosed them in quotes. 

 

Try 

Table1[COLUMN B] IN {0,1}

and see if that works

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.