Forum Discussion
filter in DAX
Hi Community I need some help....Im trying to build a DAX but I need to filter certain words which are in other column. Any suggestion to improve my DAX: MAL ASIGN = CALCULATE(COUNTROWS(b...
For your example shown in pcture, you could do something like this:
Measure = CALCULATE ( COUNTROWS ( Table ), NOT ( Table[CRANCOT2] IN { 910, 500, 502 } ) )
Hi Anonymous
Can you share some sample data and the result you are trying to acheive
Regards
Affan
it is a huge pbix... can you give me and idea or something to try affan?
where I should add a filter in that dax formula...I could use "IN" or filter function?
I mean to say that you can copy 5-10 rows of the table in excel and copy paste it in the post here and then what should be the result of the measure.
Please see this blog post to get your questions answered quickly on community.