Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Export issues

Hi Folks, I developed one of the report filtered TOP 50 records in the report but when i export into excel it's displaying 58 records, how to overcome to show only 50 records instead of 58 records.  ...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hey, what if parameter is working but since my source is tabular model so i can't create . Come to the measure point how can we  pass multiple parameters and always display the value is zero if i click on item under parameter it's not working.

Top 50ranks=RANKX(ALL('Fact Data'),CALCULATE([Paid Amount])
isdisplay = IF([Top 50ranks]<=VALUE(SELECTEDVALUE('Business Unit'[Business Unit ])),1,0)
v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, Anonymous 

 

You may try to replace 'SELECTEDVALUE('Business Unit'[Business Unit ])' with an equivalent expression as below.

var _businessunit = 
IF(
     HASONEVALUE('Business Unit'[Business Unit ]), 
     VALUES('Business Unit'[Business Unit ])
)

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.