Powerbi app is not displaying Powerbi Desktop Dax function results.

[mohsin-raza]

In my project task the function "COUNTROWS" displaying results in Powerbi desktop but when it is publishing ,it is not showing  the result with this error msg 

"MdxScript(Model) (66, 89) Calculation error in measure 'Measure Table'[Tax]: A function 'COUNTROWS' has been used in a True/False expression that is used as a table filter expression. This is not allowed."

I used this used function in all measures of the  projekt task.

[v-xulin-mstf]

Hi @mohsin-raza,

Is your issue solved?

Download the .pbix file and save locally,try to open it in desktop to see whether the measure works fine.

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[mohsin-raza · Accepted solution]

Yes, it is solved .

I modified the problem ,used the concept "set value as " and "Percent of row total" .It gives me the same result ,which is working on desktop and app.

[Fowmy]

@mohsin-raza 

Can you share the measure(s) where you have used functions to understand how they are contructed?

[mohsin-raza]

Thanks for reply. here is the measure 

Tax = CALCULATE([total],' Cost '[categori]="Tax" && COUNTROWS(FILTERS(' calender'[year])),ALLSELECTED('calender') )

I am calculating "Tax " paid by Vechicals in selected  years.(Tax by Year) 

[Fowmy]

@mohsin-raza 

I am not sure how you are implementing this measure in your project. if you want to get the TAX total for each year you can simply do the following 

Tax = CALCULATE( [total], ' Cost '[categori]="Tax" )

[mohsin-raza]

you are right!

in this task ,i  am making further analysis by taking "Which type of vechical paid  more  Tax in % " in each "Selected Year".

It works very fine in BI desktop .when i publish it ,i got the msg which i mentioned in my problem.

[Fowmy]

@mohsin-raza 

Did you modify the measure and publish it again to check the error?

[mohsin-raza]

Not yet!

I am looking for some solution to remove this error.

It is not one  category "Tax". The table conatins also other categories like  "insurance"," road taxes"  and more  of each vechical The same concept is used behind each category.

Again its work very fine in desktop not on App.i can explore the solution if not i will modify measure and test again.