Forum Discussion

mohsin-raza's avatar
mohsin-raza
Icon for Helper III rankHelper III
5 years ago
Solved

Powerbi app is not displaying Powerbi Desktop Dax function results.

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) Calculatio...
Need Help
  • mohsin-raza's avatar
    mohsin-raza
    5 years ago

    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's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

mohsin-raza 

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

  • mohsin-raza's avatar
    mohsin-raza
    Icon for Helper III rankHelper III
    5 years ago

    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's avatar
      Fowmy
      Icon for Super User rankSuper User
      5 years ago

      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's avatar
        mohsin-raza
        Icon for Helper III rankHelper III
        5 years ago

        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.